Skip to main content

SQL

SQL export in AnyWayData generates INSERT statements from the current table data.

What is SQL INSERT output?​

The SQL export format creates one or more INSERT INTO ... values ...; statements.

Example:

INSERT INTO myTable (firstname,surname,age) values 
        ('Duane','Littel-Murray',58),
        ('Jerel','Upton',39),
        ('Loy','Lehner',55);

If the dataset is larger than the configured Max Values setting, AnyWayData creates multiple INSERT statements.

AnyWayData Support for SQL​

AnyWayData currently supports exporting SQL insert statements.

Use SQL export when you want a quick way to seed test data into a database table.

Configuration options are available for:

  • table name
  • max number of values tuples per INSERT
  • whether numeric-looking values are quoted