From: "Gleb Paharenko" <[EMAIL PROTECTED]>
> Hello.
>
> In my opinion, it is not a bug. REPLACE has returned the sum
> of affected rows - one was deleted, and one was inserted. See:
> http://dev.mysql.com/doc/refman/5.1/en/replace.html
>
>
Thank you. I have seen that's the true.
Is there any MySQL command that instead of
if(record exists) {
delete line
insert new line
}
else {
insert line
}
does something like:
if (record exists) {
update record with the specified fields
}
else {
insert record
}
Thank you.
Teddy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
