Continue SQL query even on errors in MySQL workbench

by

try

mysql --force < sample_data.sql

Mysql help section says

 -f, --force         Continue even if we get an sql error.

More Related Contents:

  1. MySQL – UPDATE query based on SELECT Query
  2. How to convert an entire MySQL database characterset and collation to UTF-8?
  3. How to delete from multiple tables in MySQL?
  4. INSERT with SELECT
  5. How to get list of dates between two dates in mysql select query [duplicate]
  6. How can I find non-ASCII characters in MySQL?
  7. Using variable in a LIMIT clause in MySQL
  8. Run MySQLDump without Locking Tables
  9. SQL order string as number
  10. MySQL: Fastest way to count number of rows
  11. Find most frequent value in SQL column
  12. For loop example in MySQL
  13. How to convert number of week into date?
  14. Rails 3 ActiveRecord: Order by count on association
  15. MySQL ENUM type vs join tables
  16. MySQL – How to SUM times?
  17. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  18. mysql root password forgotten
  19. Should I use MySQL blob field type?
  20. Does MySQL overwrite a column of same value on update?
  21. How to make join queries using Sequelize on Node.js
  22. mysql like performance boost
  23. MySQL selecting yesterday’s date
  24. Returning records from the last 3 months only in MySQL
  25. WooCommerce: Finding the products in database
  26. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  27. Mysql performance on 6 million row table
  28. How can I “select *” from a table in MySQL but omit certain columns?
  29. MySQL Select Multiple VALUES
  30. Convert SQL Server query to MySQL [duplicate]

Leave a Comment