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?
Solution
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'
- php - Explode string and insert into multiple rows with foreach is too slow
- MySQL connection over SSH tunnel
- select * from table1, table2 where table1.id = 1 showing values with other id
- How do I convert german dates to MySQL standard dates?
- Show all Duplicate value of a specific column in mysql
- Why is MySQL more picky about parentheses in union subqueries than in normal queries
- MariaDB Not Starting: "Plugin 'FEEDBACK' is disabled."
- Consistent Access Denied error when trying to connect to MySQL DB with PDO
- How can I store MySQL results in different individual variables with one connection to the database?
- Sequilize query is returning only one row while using include
- Replicate MySQL Data to ClickHouse
- I am trying to create a stored procedure to check passwords of logins
- MySQL won't start - error: su: warning: cannot change directory to /nonexistent: No such file or directory
- Why my query is slow even with less data?
- UPDATE vs INSERT performance
- Create column display number of image in MySQL
- Why am I getting the "MySQL server has gone away" exception in Django?
- Concat in EXCEL like MySQL
- In MySQL, how can I specify an optimizer hint for a nested WHERE IN?
- MySQL multiple EXISTS statements causes query to hang
- How to pass DBNull in Nvarchar type(procedure paramter) in MySql
- How to Efficiently Find Consecutive Rows with Matching Criteria in SQL?
- mysql2 gem compiled for wrong mysql client library
- Do I need to use await when calling connection.release() in mysql2?
- Change Data Type for MYSQL UPDATE for error 1292 Truncated Error Double Value on WHERE failing on VARCHAR(45)
- How to change the default port of mysql from 3306 to 3360
- How to install Mysql-server in Ubuntu offline
- MySQL column value not exist in other column on the same table
- How to create FULLTEXT index on multiple columns?
- Grouped results with counts using two fields