On Dec 16, 2007 10:29 AM, Afan Pasalic <[EMAIL PROTECTED]> wrote: > try REPLACE > http://dev.mysql.com/doc/refman/5.1/en/replace.html > > -afan Replace will not do an update. All previous data will be lost.
A mysql-centric alternative solution would be to use INSERT ... ON DUPLICATE KEY UPDATE http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]