Member Avatar for arwenvd

Hello to all reading this thread. I want to ask you a question about mysql records and more specifically deleting them. I have a database which has a table called orders. In orders I have fields: ID, Name, Date created, Date expire. My question is, how can an order be deleted at the "Date expire" ? I want the MySQL do it itself, so I would not be required to login and delete it mysqlf. Thanks for the time and hopefully I'll get it :) Good day all!

  • 5 Contributors
  • 6 Replies
  • 262 Views
  • 4 Weeks Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for debasisdas

You need to schedule that using Event Scheduler.

Create a procedure to delete the desired records and schedule the same.

please read more here and here.

Member Avatar for Anuradha Mandal

Plz write some code and find out the problem.

commented: don't post mindless stuff -3
Member Avatar for pratik_garg

debasisdas has posted good link
@Anuradha Mandal - atleast try to put some effort to read it ...

you can post problem, if you are getting any to write this scheduling or anything else (although this thread has not started by you)....

commented: Do not understand????? +0
Member Avatar for pritaeas

Although debasisdas has pointed you in the correct direction, if you are on a shared web host, chances are you cannot turn on the scheduler. In that case you may be able to use a cron job.

commented: agree +13
commented: What are you saying? +0
Member Avatar for Anuradha Mandal

I can not understand what are you want to explain? Plz tell me the detail "pratik_garg,
pritaeas".Plzz.

commented: out is the way to go. -3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.