|
Posted by Martin van den Berg on 10/04/82 11:24
> I have lots of places where I used to do this. Since MySQL 4.1 I've
> changed it to something like:
>
> "INSERT INTO mytable SET id = 123, bla = '$x' ON DUPLICATE KEY UPDATE
> bla='$x'"
>
> This saves you a query, and makes it easier to isolate the insert/
> update as it will play nicely with autocommit.
>
Neat construction but in my case, id is an auto-increment field... so
I guess your example won't work since I never get a duplicate key.
Navigation:
[Reply to this message]
|