t
---
-Original Message-
From: Andre Matos [mailto:[EMAIL PROTECTED]
Sent: Sunday, 12 February 2006 2:23 PM
To: George Law; mysql@lists.mysql.com
Subject: Re: Insert and Update together
No George. I took a look there before sent this
plicate key update set x=2,y=5;
>
> unfortunately, the server I was testing this on was running 4.0.x so I
> couldn't use it.
>
>
> http://dev.mysql.com/doc/refman/5.0/en/insert.html
>
>
>
> - Original Message -
> From: "Andre Matos" &l
Oops, I meant to send this to the list so that everyone could benefit, not
just to Andre.
--
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Andre Matos" <[EMAIL PROTECTED]>
Sent: Saturday, February 11, 2006 12:11 PM
Subject
as testing this on was running 4.0.x so I
couldn't use it.
http://dev.mysql.com/doc/refman/5.0/en/insert.html
- Original Message -
From: "Andre Matos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 11, 2006 10:54 AM
Subject: Insert and Update together
Hi Li
Hi List,
I would like to know if it is possible to combine Insert and Update in one
SQL instruction. This is what I want to do:
I have two tables: one where I will perform and Update replacing "m0" by
"scr". If MySQL find a "m0", it will need to perform an insert into a log
table including the in
