|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Can mySql automatically delete an entry based on a date?
Can I set up mysql so that, on a predetermined date, an entry will automatically be deleted? For example, in a job-posting database, if the viewer adding the job posting wants to, the ad they place will only run to a certain date which they will determine, then mysql will automatically delete their ad right after the predetermined date. Is this possible, so that I dont have old ads that are no longer valid, and have to remove them myself?
|
|
#2
|
|||
|
|||
|
RE: Can mySql automatically delete an entry based on a date?
You can use a cron job to accomplish this, it can just call a PHP script that deletes any old records.
|
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Can mySql automatically delete an entry based on a date? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|