Home >Database >Mysql Tutorial >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!