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(a)openser.org >>http://openser.org/cgi-bin/mailman/listinfo/users >> >> >> >> >>