Andre,
I tried this a couple weeks ago... I think you want the "on duplicate"
option for the INSERT query.
depends what version you have... I think this was introduced in mysql 4.1
insert into xxxx values (....) on duplicate 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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, February 11, 2006 10:54 AM
Subject: Insert and Update together
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 information updated.
I am trying to avoid writing a php4 program to do this. I am using MySQL
4.1
Thanks for any help.
Andre
--
Andre Matos
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
