I want to delete a table after 15 days automatically from the date of its creation , please soem one help me to find out the solution , Some one suggest me to use trigger but i search a lot but unable to find out the solution .

Recommended Answers

Have a look at MySQL events which allow you to run code at a certain time.

Jump to Post

All 2 Replies

You could always run a Cron task, the draw back being that you would need to know the time the table was created.

For example:

  • Table Created
  • Setup Cron (* * */15 * *) to Run Scripts
  • Table Deleted Every 15 Days
Be a part of the DaniWeb community

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