| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Gold Sponsor 2015! |
|CronJob and MySql updates|
Hi, I run a forum and need to run some updates to the mysql database every 24 hours via a cron job.
Here is my SQL Update query
update members set ID_GROUP="12" where ID_group="0"
so i want to put this in a file called update-group.sql
but not sure on the formate of the sql file.
i would like the sql file to contain the login info for the database aswell
can anyone help?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved