[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:

  <http://dev.mysql.com/doc/refman/5.0/en/insert.html>

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

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

                          dream.  code.





More information about the thelist mailing list