How to import sql file into mysql

This article will give you a detailed introduction to the method of importing sql files into mysql. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

The first step: Find mysql in the start interface

The second step: Double-click to open the mysql software. , and enter the password.

Step 3: If there is a statement to create a database in the content of the sql file or you want to store the table in your existing database, there is no need to create a database here.

#Step 4: Enter "show databases;" to see the database you created.

Step 5: Enter "use database name" to start using this database.

Step 6: Start importing the sql file and enter the "source sql file path" (note that if your file path is copied, you must replace all "\" into "/")

Step 7: Enter "show tables" and you will see the tables you imported.

Related recommendations: "mysql tutorial"

The above is the detailed content of How to import sql file into mysql. For more information, please follow other related articles on the PHP Chinese website!