How can we run MySQL statements in batch mode?

We need to create a .sql file for running MySQL in batch mode. This file will contain MySQL statements. Suppose I have a hh.sql file in which I wrote a select * from hh statement. We can run this file in batch mode with the help of the following command −

Example

C:\Program Files\MySQL\bin>mysql -u root -p gaurav < hh.sql
Enter password: *****

Output

id
1
2

Here Gaurav is the database containing table hh name. Whenever you run this command, it will ask for the password and then give the output.

The above is the detailed content of How can we run MySQL statements in batch mode?. For more information, please follow other related articles on the PHP Chinese website!