Getting Started with Datagrip-exporting data (iv)

Datagrip's export function is also quite powerful

Select the table you want to export data from, right-click, Dump data to File

That is, you can export SQL statements in the form of INSERT, update, and export to HTML, CSV, and JSON-formatted data

You can also export in the query results view

Click the download icon in the top right corner to choose a different way to export, such as SQL Insert, SQL UPDATE, CSV format, etc.

If you export to CSV format, you can also control the format of the export

Open with Excel After export is this result

In addition to exporting data, you can import data

Select a table, right-->import from file, select the file to import

Note that when exporting if the two header option is checked on the left, if there is a header in the import, it should be checked, otherwise the number of columns will not match.