Navicat three ways to export data in a table (simple data, excluding table structure)

navicat Export Table A total of three uses:

The first: the database right-> "dump SQL Files", as shown in the figure:

"Dump file" is to export the entire database table, all tables are first drop then Create,insert.

Second: Partial table export, select the table you want to export, and then right-click the Export Wizard->. You can then proceed to the next step, as shown in figure:

The disadvantage of this method of exporting is that each table will export a single file, with a lot of files generated. Import files are imported in turn, the workload is very large, very troublesome. The effect is as shown when exporting:

The third method is recommended, select the table you want to export, and then right-click-> "Dump SQL File", as shown in the figure:

The advantage of this export is that the exported n multiple tables exist in an SQL file. The file name is the first table name to be exported, and all data is inserted by inserting each piece, not an insert insert multiple data (this is the first method when inserted), so that it is more flexible, such as a table too large , the data is too much, you can truncate, partial upload.