Two solutions for importing SQL scripts from MySQL

The following articles mainly introduce two simple methods for importing SQL scripts from MySQL. On some websites, I see the actual operation solution for importing SQL scripts from MySQL, the operation process is not simple. The following articles mainly introduce a simple solution for importing SQL scripts to 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. You do not need to convert the directory)

 
 


  
  
> MySQL-u root-p123

 
 

After entering MySQL

 
 


  
  
MySQL> use test;

  
  
MySQL> source c:/test. SQL

 
 

After running OK, you can use show tables to check which table has been written. Remember that the statement has a semicolon)

You can also use desc tableName; to view the structure of your table.

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

 
 


  
  
D: \ MySQL \ bin> MySQL-u root-p123 test <c:/test. SQL

 
 

The above content describes how to import SQL scripts to MySQL. I hope it will help you in this regard.