HACKATHORN, TODD (SWBT) wrote:
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import cu
Are you using the DTS to schedule replication or periodic data imports?
>> Original Message <<
On 2/25/04, 11:48:02 AM, "HACKATHORN," TODD "(SWBT)" <[EMAIL PROTECTED]> wrote
regarding updating tables in MySQL:
> Hello,
> Sorry if this is a obvious question, but
Tivano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 10:50 AM
Subject: Re: updating tables
> Stefan,
>
> The problem look be solved;
>
> i've just changed structure of the updatable table.
> First this table have only 1 primary k
Stefan,
The problem look be solved;
i've just changed structure of the updatable table.
First this table have only 1 primary key, now my table have some indexed unique keys.
and now if i do a replace into command look's like to work fine.
I have just a question:
i need also to change structur
Fabrizio,
please send the table structures of table_1 and table_2 (DESCRIBE ...)
so we can do more for you than just guess what the problem might be.
REPLACE seems good in the first place, but if it just INSERTs then
there's a problem with the (primary) keys.
Regards,
--
Stefan Hinz <[EMAIL PR
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
