How to import sql file into mysql database

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

##More related free learning recommendations: mysql tutorial(Video)

How to import sql files into mysql database:

1. Find mysql in the start interface.

#2. Double-click to open the mysql software. , and enter the password.

#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.

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

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

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

#7. Enter “show tables” and you will see the tables you imported.

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