mysql query question

Steve Prior sprior at geekster.com
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.

Steve

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 linuxfromscratch.org
and put 'unsubscribe blfs-support' in the subject header of the message



More information about the blfs-support mailing list