MySQL script execution Method

2. Execute the SQL script file
Method 1Run the doscommand (in windows, Unix or Linux on its console)
[MySQL bin directory] \ mysql-u user name-P password-D database <[full name of the SQL script file path], example:
D: \ mysql \ bin \ mysql-H localhost-uroot-p123456-Dtest <D: \ test \ ss. SQL
Note:
A. If the use database is used in the SQL script file, the-D database option can be ignored.
B. If the bin directory of MySQL contains spaces, use "" to include, for example, "C: \ Program Files \ mysql \ bin \ mysql "-u user name-P password-D database <[full name of the SQL script file path]

 

Method 2Log on to the MySQL console and run the source command.
Mysql> source [full name of the SQL script file path]