MySQL Execute SQL file

Mysql-uspider_55haitao-pspider_55haitao-dspider_55haitao

method One executes with the cmd command (under Windows, UNIX or Linux under its console)
"MySQL Bin directory" \mysql–u user name –p password –d database < "SQL script file path full name" Example:
D:\mysql\bin\mysql–uroot–p123456-dtest<d:\test\ss.sql
Attention:
A, if the use database is used in a SQL script file, the-d database option can be ignored
B, if "MySQL Bin directory" contains spaces, you need to use "" "include, such as:" C:\Program files\mysql\bin\mysql "–u username –p password –d database <" SQL script file path full name "

method Two after entering MySQL console, use the source command to execute
Mysql>source "path full name of SQL script file" or mysql>\. "Path full name of SQL script file", example:
source D:\test\ss.sql or \. D:\test\ss.sql

MySQL Execute SQL file