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

This article shows you how to export the database SQL file in HeidiSQL, 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.

HeidiSQL is an excellent MySQL/SQLserver management client under open source and free Windows. This article describes how to export database files.

Right-click in the database administration or right-click on the selected datasheet and select "Export database as SQL" from the pop-up menu.

In the pop-up window, we can see:

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

There are several projects to export "Output" here:

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

There are also options in data, as we can see:

We can see the following options:

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

The above is how to export database SQL files in 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.