即使在MySQLworkbench中出现错误，也要继续执行SQL查询-ContinueSQLqueryevenonerrorsinMySQLworkbench

29  

You could also use INSERT IGNORE

还可以使用INSERT IGNORE

INSERT IGNORE INTO mytable
 (primaryKey, field1, field2)
VALUES
 ('1', 1, 2),
 ('1', 3, 4), //will not be inserted
 ('2', 5, 6); //will be inserted

25  

In MySQL Workbench, I unticked the option under Query to "Stop Script Execution on Errors":

在MySQL Workbench中，我去掉查询下的选项“错误停止脚本执行”:

It looks like Zimbabao's answer will work also.

看起来辛巴威的答案也同样有效。

In newer versions use 'Toggle whether execution of SQL script should continue after failed statements'

在较新的版本中，使用'切换SQL脚本在失败语句之后是否应该继续执行'