SQL database import and export step tutorial (picture)

Generating and executing MYSQL database scripts are two mutually reverse operations. This sentence may be a bit difficult to understand. In layman's terms, generation is export, and execution is import. Let's take a look at how the MySQL database imports and exports data tables.

Export of sql database

##Click to execute

Then you can generate a .sql file

Import of sql database

Let’s take a look at how to import. sql file, we first delete the admin table of the database study, so that there is no data in the database.

As shown in the picture above, there are no tables in our database. Then look at the above, there is import, click import, we will see a page like this, as shown in the picture below:

We can see a button to select a file. We can just select the .sql file and then execute it,

In this way we successfully imported the sql file into the database study

The above is the detailed content of SQL database import and export step tutorial (picture). For more information, please follow other related articles on the PHP Chinese website!