Shulou(Shulou.com)05/31 Report--

This article shows you how to use HeidiSQL to import and export MySQL data, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

① first, select the database you want to export and click the right mouse button: as shown in the following figure

② here is to select and export the contents of a database you want to export.

The meaning of ③ for each option in the operation

The parameters of each of the above options are explained here

No Date: no data is exported, only data table structure

Delete+Insert (... ): clear the contents of the data table and insert the new content of the export

Insert: insert only new content

Insert Ignore: insert data to ignore error content

Repalce: replace insert

One big file: export a SQL file

Diretcoty... A separate file for each table is stored in a specific folder

Clipboard: exporting to clipboard

Database: import into another database

Server: import to another server

The above database (s) and table (s) have two options, "Drop" and "create", respectively. If checked, the generated SQL statement contains statements to delete and create a database or table, which we usually check.

Here export "Output" the data we choose we want to export

④ choose the path you want to save and click Export to export the data.

The result data was exported successfully

2. Now let's explain how to import data. For example, we have a script file called emp.sql, where we import data with HeidiSQL.

① will now explain to you the specific operation flow.

Select the sql script you want to execute, click data Import, and everything is successful.

The above content is how to import and export MySQL data using HeidiSQL. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.