CronJob and MySql updates

[ulk26]

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?

[phranque]

welcome to WebmasterWorld [webmasterworld.com], ulk26!

you can't put the login information in the sql file.
it is provided in the command line:

mysql -uusername -ppassword databasename <update-group.sql

[ulk26]

Thanks for the reply, what format do i need to put in the sql file

or is it a case of just putting in my update query?

[phranque]

yes you simply put the sql statements in the .sql file and use stdin or pipe it into your mwsql command.

[ulk26]

ok thanks