Here is a select statement, as example:
mysql -e "select * from user \G" mysql
Add user and password as required.
Xi2 ('sE-'t�)
-----Original Message-----
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 8:57 AM
To: [EMAIL PROTECTED]
Subject: Updating tables via cron
I tried to search the archives for this but I can't find it. (Not
saying
it isn't there just I could not find it.) I have a table that tracks
events on a monthly and daily basis. Currently I am resetting the
appropriate fields to 0 on a daily and monthly basis (not fun). Is there a
way to set a command in the cron table to do this for me
automatically? Here are the details.
db name: activity
daily field name: dr (needs to be reset to 0)
monthly field name: mr (same as above)
I know how to tell cron the date/time I want an event to trigger,
but I
don't know the syntax of the command to send. Any help would be
appreciated.
Thanks,
David
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
