MySQL 4.1 Script Update Table Help needed. 2

[Cranger]

Hi All.

OK, like most threads on here, I am a newbie.

We have a MySQL 4.1 Database running on a RedHat Linux box. Every so often (nightly?), I want to run a job against the tables to select the records from "X" Days ago and update a flag in that table. First, can this be accomplished? And second, can anyone point me in the right direction?

Thanks.

 

[johnwm]

I notice that you haven't as yet marked any of the answers given to you as valuable. If you're not getting the right answers, read faq222-2244 to see why - if they are the right answers, please mark them so others using the forum will recognise useful answers.

For this question, the MySQL manual is a good starting point. Look up the UPDATE query

http://dev.mysql.com/doc/refman/4.1/en/update.html

which gives a detailed example. If you have a further problem, show us what you've tried, and what result you get so we can be of more specific help.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[Cranger]

thanks johnwm,

I understand about writing an update query, but I am not sure how I can regularly run it. Do I have to write a stored procedure and envoke it via shell script? Can I run the query on a schedule?

 

[johnwm]

Thanks for your response. The 'regularly run' bit will probably be covered in the Linux desktop forum forum619

Sorry I can't help directly, but I don't do Linux (yet)

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[TonyGroves]

You can certainly have it run as a cron job. That involves adding an entry to /etc/crontab, with a command something like:[tt]
mysql -u username -ppassword dbname -e 'update tbl set flag=1 where dt=curdate()-interval 5 day'
[/tt]
The "man crontab" command will explain the file's syntax.

 

[Cranger]

excellent. Thanks Tony.