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]