Continue SQL query even on errors in MySQL workbench
I'm using MySQL workbench to import a Joomla sample_data.sql file into my local database. I want it to continue importing, even if an error occurs, by skipping the line that caused the error.
Is there something I can prefix the SQL with to prevent the query from halting at any errors?
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
In MySQL Workbench, I unticked the option under Query to "Stop Script Execution on Errors":
It looks like Zimbabao's answer will work also.
In newer versions use 'Toggle whether execution of SQL script should continue after failed statements'