Several methods to execute sql files under mysql command line

To achieve the goal: Import the tsinfo180516.sql file into the database demo1 through the command line.

Rendering

The first method: When the MySQL database is not connected

Execute the sql file in the mysql command line

Run --cmd

C:\Users\lenovo>mysql -u account -p password -D database name < sql file absolute path

C:\Users\lenovo>mysql -uroot -proot -Ddemo1<C:\Users\lenovo\Desktop\tsinfo180516\tsinfo180516.sql

The second method: When the database is already connected, the command prompt is mysql>.

Enter the password to connect to the database

Practical record of importing SQL files using MySQL source command

Enter the full path of the source script or \. full path of the script

For example: source <C:\Users\lenovo\Desktop\tsinfo180516\tsinfo180516.sql

Or \. <C:\Users\lenovo\Desktop\tsinfo180516\tsinfo180516.sql

This concludes this article about several methods of executing SQL files under the MySQL command line. For more information about executing SQL files under the MySQL command line, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!