[Users] mysql insert

Helge Waastad helge at smartnet.no
Fri Dec 1 14:16:35 CET 2006


Hi,
No you are correct. This is not SQL92 but MySQL specific.

I am stress-testing my registrar using sipp, and every register has the
same primary keys, which then generates a duplicate key error from the
database.

br hw


fre, 01,.12.2006 kl. 13.19 +0200, skrev Bogdan-Andrei Iancu:
> Hi Helge,
> 
> duplicated entries in location table should never happen. Can you 
> describe the scenario you get this?
> 
> also your suggestion cannot be put in practice due limitation of the 
> internal DB api - it is not so complex to allow such mysql commands. 
> Also I'm not sure if this syntax in SQL 99 compliant and is not 
> something mysql specific.
> 
> regards,
> bogdan
> 
> Helge Waastad wrote:
> 
> >Hi,
> >just a little question about mysql insert into location.
> >I might be wrong here, but please be patient whith me. Im not too good
> >to read through the source tree.... :-)
> >
> >Would there be anything wrong with changing the insert statement from
> >insert into.....
> > to:
> >insert into.....on duplicate key update.....
> >
> >(my sipp register stress-test scenario gave me this idea....)
> >
> >br hw
> >
> >
> >_______________________________________________
> >Users mailing list
> >Users at openser.org
> >http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >  
> >
> 




More information about the Users mailing list