[thelist] fileopen v mysql_query was insert if select fails to find element

Hassan Schroeder hassan at webtuitive.com
Fri Nov 18 10:02:34 CST 2005

Alex Beston wrote:

>>As above, set a UNIQUE index on the field, but use INSERT IGNORE to
>>convert duplicate-row-errors to warnings.
> Yes, that worked quite nicely; I guess whats its doing is overwriting 
> whats already there.

No, but the FM is your friend:


:: including info on `IGNORE` and `ON DUPLICATE KEY UPDATE`; highly
recommended reading *before* using these statements... :-)

Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.

More information about the thelist mailing list