Using MySQL in batch mode

#MySQL can be run in batch mode. To do this, you need to put the statements that need to be executed into a file, and then "mysql" should be instructed to read input from this file. It can be done as follows -

shell> mysql < batch&minus;file

If mysql is running on Windows and there are certain special characters in the file that may create problems, you can run the following lines of code -

C:\> mysql −e "source batch−file"

if needed To specify the connection parameters on the command line, you need to execute the following line of code -

shell> mysql &minus;h host &minus;u user &minus;p < batch&minus;file
Enter password: ********

When running mysql in this way, a script file will be created and further executed. It's important to understand why you need to use a script -

• If you must run queries frequently, creating a script will avoid having to re-enter the code each time it needs to be executed.

• Note: If you must continue executing the script even if some statements produce errors, you must use the "--force" command line option

• Simply copy and edit the script file to generate new queries from existing queries that are similar to each other.

• Batch mode is very useful when developing queries and it works well even if it is a multi-line statement or sequence of statements. If an error occurs, you don't have to re-enter all the code. The script can simply be edited to correct the error, and then "mysql" can be commanded to execute the script file again.

If a query produces a lot of output, the output can be run through a pager instead of allowing it to scroll to the top of the screen. This can be done using the following command -

shell> mysql < batch-file | more

The output can be stored somewhere and further processed -

shell> mysql < batch-file > mysql.out

The script can also be shared/distributed with others so that they can execute the statements .

The above is the detailed content of Using MySQL in batch mode. For more information, please follow other related articles on the PHP Chinese website!