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
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
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
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