Implementation Method for continued execution after an error occurs in the mysql batch file.

Implementation Method for continued execution after an error occurs in the mysql batch file.

When upgrading the SQL script for batch processing, we usually want to stop the SQL script after it fails because it is not standardized and cannot be executed repeatedly. Although these problems can be solved by writing repeated mysql stored procedures, such as add_column/drop_column, the off-the-shelf versions usually require a long transition, therefore, this requirement is still necessary.

In fact, it is very simple, just add the -- force command line option, as shown below:

Mysql-uroot-ppassword--force [db] <patch. SQL

The above is all the implementation methods for mysql batch processing files to continue to be executed after an error occurs. I hope you can provide more support ~