> REPLACE is a MySQL extension to the SQL standard. It either inserts, or > deletes and inserts. For another MySQL extension to standard SQL — that > either inserts or updates — see Section 13.2.4.3, “INSERT ... ON DUPLICATE > KEY UPDATE Syntax”.
Take note!! If you're using triggers, foreign key constraints or defaults on columns, it is better to use ON DUPLICATE cause it will update instead of deleting the row first. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]