How I Delete A table automatticly after 15 Days

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 .

Contributors

Replies

7 Hours

Discussion Span

8 Months Ago

Last Updated

Views

pawan768

Light Poster

31 posts since Nov 2011

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

8 Months Ago

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

smantscheff

Nearly a Posting Virtuoso

1,297 posts since Oct 2010

Reputation Points: 321

Solved Threads: 270

Skill Endorsements: 8

8 Months Ago

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

AHarrisGsy

Posting Pro in Training

493 posts since Nov 2011

Reputation Points: 52

Solved Threads: 40

Skill Endorsements: 13

This article has been dead for over three months: Start a new discussion instead

You