MySQL

Moderators: Jonathan
Number of threads: 266
Number of posts: 525

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Auto Delete Table Info from demo Posted by NYColt on 12 Feb 2003 at 8:18 AM
Can anyone tell me if there is a way for me to, every few hours or once or twice a day automatically delete information, photos, etc that customers may add to my demo program using a mysql database that I have on my site.

Any help would be great.

Thanks
NYColt
Report
Re: Auto Delete Table Info from demo Posted by Jonathan on 15 Feb 2003 at 12:59 PM
: Can anyone tell me if there is a way for me to, every few hours or
: once or twice a day automatically delete information, photos, etc
: that customers may add to my demo program using a mysql database
: that I have on my site.

Hmmm...I'm not certain if MySQL has a tool itself to do this, but you can always write a script in your favorite scripting language that connects to the database and runs queries to do the required deletion. Then add that script to your cron tab to get it to be executed automatically. Should work a treat.

Jonathan


-------------------------------------------
Count your downloads:
http://www.downloadcounter.com/
And host your site:
http://www.incrahost.com/
Don't say I never give you anything...




 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.