Home>Article>Database> How to import sql file in mysql

How to import sql file in mysql

青灯夜游
青灯夜游 Original
2019-05-06 14:14:42 104728browse

Mysql Steps to import sql files: 1. Find mysql in the [Start] interface, double-click to open the mysql software, and enter the password; 2. Create a database; 3. Enter "use database name" to start using this Database; 4. Enter the "source sql file path" command to import the sql file.

How to import sql file in mysql

SQL file is a very important file for the database. Converting the sql file into a data file is a very important skill for using the database. The following article will introduce to you how to use mysql to import sql files. I hope it will be helpful to you.

1. Find mysql in the start interface, double-click to open the mysql software, and enter the password.

How to import sql file in mysql

How to import sql file in mysql

2. Create a database

You can create a database and then import the sql file into the database; you can also import sql file is imported into an existing database. The create databases statement is used here to create a database.

How to import sql file in mysql

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

How to import sql file in mysql

#4. Enter "use database name" to start using this database.

How to import sql file in mysql

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

How to import sql file in mysql

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

How to import sql file in mysql

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn