mysql 遇到错误继续,即使在MySQL工作台中发生错误也继续执行SQL查询

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?

解决方案

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'