Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to import sql files into mysql database. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

The way to import the sql file into the mysql database: first open the mysql and enter the password; then create the database and enter the "use database name"; finally, start importing the sql file and enter the "path to the source sql file".

How to import a sql file into a mysql database:

1. Find mysql in the start screen.

2. Double-click to open mysql software. And enter the password.

3. If the sql file contains a statement to create a database, or if you want to store the table in your existing database, you do not need to create a database here.

4. Enter "show databases;" and you can see the database you created.

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

6. Start importing the sql file and enter "the path to the source sql file" (note that if your file path is copied, replace "\" with "/")

7. Type "show tables" and you will see the table you imported.

On how to import sql files into the mysql database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.