How I Delete A table automatticly after 15 Days

[pawan768]

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 .

[smantscheff]

Have a look at MySQL events which allow you to run code at a certain time.
http://dev.mysql.com/doc/refman/5.1/en/events-overview.html

[Octet]

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