Home / server / Questions / 410993
Accepted
w00t
Asked: 2012-07-26 01:27:18 +0800 CST

MySQL continue after Duplicate entry error

  • 772

I'm running a 'bash for' script to update some records in mysql, like so:

for i in `cat yahoo.txt`; do mysql $DB --batch -fe "update users set email=concat(left(email, instr(email, '@')), 'yahoo.com') where email like '%@$i';" ; done

but even with --force, the update stops after the first error:

ERROR 1062 (23000) at line 1: Duplicate entry '[email protected]' for key 3

Is there anyway I can force it to continue?

mysql

1 Answers

  1. Best Answer

    try changing update to update ignore

    http://dev.mysql.com/doc/refman/5.0/en/update.html :

    With the IGNORE keyword, the update statement does not abort even if errors occur during the update. Rows for which duplicate-key conflicts occur are not updated. Rows for which columns are updated to values that would cause data conversion errors are updated to the closest valid values instead.

    • 3