mysql query question

Steve Prior sprior at
Mon Jul 14 14:20:11 PDT 2003

In Oracle you would do:

1. try to INSERT
2. if you get a duplicate exception on the primary key then switch to update.

Don't know if Mysql does exceptions the same way or not.


Alexander Newald wrote:
> Hello,
> I know that it is not really blfs related but I had no sucsess elsewhere:
> How do I manage to get "if exists UPDATE else INSERT" in mysql working?
> replace is not the solution.
> Thanks,
> Alexander Newald

Unsubscribe: send email to listar at
and put 'unsubscribe blfs-support' in the subject header of the message

More information about the blfs-support mailing list