SQL script imported from MySQL

For example, if my user name is root and the password is 123 SQL script, the C disk name is test. The SQL database name is test.

There are two ways to execute the script

1: Open CMD and enter the following command (directory conversion is not required)

>MySQL-U root-p123

EnterMySQLAfter
MySQL> Use test;
MySQL> Source C:/test. SQL

After running OK, you can use show tables to check which table is written (remember that there is a semicolon after the statement)

You can also use DESC tablename; to view the structure of your table.

2: Open CMD and enter the following command (enter the bin directory of MySQL)

D: \ mysql \ bin>MySQL-U root-p123 test <C:/test. SQL