Save to SQL file

save sql

Filename: the name of SQL file to save data to.

It supports dynamic filenames including date, you can set the filename like this: abc_#yyyy#_#mm#_#dd#_#hh#_#mi#_#ss#.sql. #yyyy# is for current year, #mm# month, #dd# day, #hh# hour, #mi# minute, #ss# second. It's a template filename, the output file will like this: abc_2024_09_15_12_20_55.sql.

Encoding: file encoding.

DB Type: Access / DB2 / DBF / MySQL / Oracle / PostgreSQL / SQL Server / SQLite.

Table Name: the table name in SQL clause.

Convert Mode: Insert / Update / Upsert.

Select All: select all columns.

Select None: select none columns.