Continue SQL query even on errors

MySQL错误处理技巧

最新推荐文章于 2025-02-08 15:50:30 发布

转载最新推荐文章于 2025-02-08 15:50:30 发布 · 58 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/emanlee/p/4612309.html

try
mysql --force < sample_data.sql

Mysql help section says
-f, --force Continue even if we get an sql error.

----------------------
You could also use 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

----------------------
You can use INSERT... IGNORE syntax if you want to take no action when there's a duplicate record.

You can use REPLACE INTO syntax if you want to overwrite an old record with a new one with the same key.

Or, you can use INSERT... ON DUPLICATE KEY UPDATE syntax if you want to perform an update to the record instead when you encounter a duplicate.

----------------------