So im having trouble figuring a procedure in mysql that deletes a somethingt in a table every 10 minutes, say it
has name, address, id and idk, the date, so i do something like this:
create event delete
on schedule every 10 minutes
starts current timestamp
on completion preserve
delete from student
and then from here im lost, maybe a begin/end or i dont need to? the examples i find are with insert, so delete seems way more complicated due to the tables probably using foreign keys. I probably have to use a where after but im not sure how to start.
Im sorry if the question is weird, this webpage honor code makes asking questions real hard without having issues in some way.
Recently Asked Questions
- The question is about various lectures that are available for students at a conference. Each lecture addresses a topic, is presented by a lecturer. There are a
- This question is based on the View Ridge Gallery database you have been using in the labs. See the textbook for background to the case and the table
- What is Dates and Times data types? What are the implementation problems of Dates and Times data types? Discuss solutions for these problems.