Exporting a data table as SQL commands
Wizard can export data tables as a set of Structured Query Language (SQL) commands. The SQL export format can be used to load data into a MySQL or PostgreSQL database.
To export a table as SQL:
- Select the table you wish to export in the navigator
- Choose Table > Export Raw Data > Export SQL
- Enter a file name, select the desired SQL dialect (MySQL or PostgreSQL), and press Save
Note that the exported table will include the same rows currently visible in the Raw Data view. You can thus export a subset of the table using the filters pane.
See also:
Importing from a database server
Exporting a data table as CSV, XLS, RData, SQLite, or JSON
Exporting a data table as a binary file for Stata or SPSS (Pro only)
About data filters
List of supported file formats