Re: Updating tables via cron

2002-01-04 Thread zb
Hi! On Thu, 3 Jan 2002, Webmaster wrote: > 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

Re: Updating tables via cron

2002-01-04 Thread DL Neil
David, Was this question addressed? > 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 mon

RE: Updating tables via cron

2002-01-03 Thread Gary . Every
Try this: echo "REPLACE INTO table_name (dr) VALUES ('0');" | /usr/local/mysql/bin/mysql -u user -p password activity or mysql -e "REPLACE INTO table_name (dr) VALUES ('0');" activity -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 10:57 AM

RE: Updating tables via cron

2002-01-03 Thread Land, Christopher
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