Using MySQL batch processing in Windows (v)

First, how to execute the statement in bulk

1. Save the script as a script file, such as Company.sql

2. Execution of commands

Mysql-h host-u user name-P <d:\dbdata\company.sql

Enter password:******

Second, pagination display

Mysql-h host-u user name-P <d:\dbdata\company.sql | more

Third, capture the output results

1. Output File Companyresult.out

Mysql-h host-u user name-P <d:\dbdata\company.sql >companyresult.out

2. Record in output file as if a single command is executed in MySQL

Mysql-h host-u user name-P <d:\dbdata\company.sql >companyresult.out -vvv

3. Display the results in the output file by grid

Mysql-h host-u user name-P <d:\dbdata\company.sql >companyresult.out- t