mysqlhalt
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'
- C# Entity Framework: Keyword not supported: 'port'
- mysql update with regexp
- Checking for valid MySQL result resource
- How to connect and insert record to mysql using c language?
- MySQL JSON datatype count and groupby
- Scan error: unsupported Scan, storing driver.Value type <nil> into type *string
- MySQL Testcontainer Timezone Issue When Using Spring Data JDBC
- How to start MySQL server from command line on Mac OS Lion?
- Import data.sql MySQL Docker Container
- Fire a trigger after the update of specific columns in MySQL
- MySQL auto-increment between tables
- After MySQL install via Brew, I get the error - The server quit without updating PID file
- Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- How to select both sum value of all rows and values in some specific rows?
- MySQL: Cloning a MySQL database on the same MySql instance
- How to get number of a specifc row php
- MySQL collation to store multilingual data of unknown language
- Is there any bad of disable FULL_GROUP_BY
- WordPress Editor not updating files: Unable to communicate back with site to check for fatal errors
- Weird autoincrement issue on Spring Boot 3.3.0 with MySQL 8
- Data truncated for column?
- MySQL get a random value between two values
- Convert Mysql Dump File from INSERT to INSERT IGNORE
- MySQL column that will check if a date column is past 30 days
- Can't connect to mySQL server from wsl
- All data is become NULL when run Update Query MySQL
- Cross Join to DQL
- How to implement Fuzzy search in strapi cms
- one query for all array data! result is by separating for each id of array
- Invalid datetime format: 1366 Incorrect string value