SQL dump fixtures

Postgres- and MySQL-flavour SQL dumps with CREATE TABLE and INSERT statements — for testing SQL importers and migrations.

Filter these filesAll categoriesSource codeDataAll purposesCode parsingEditor testingSQL import

8 of 8 files

sql

276 B

Postgres SQL Dump

A Postgres-flavour SQL dump with a CREATE TABLE and INSERT statements — for testing SQL importers and migrations.

File

SQL · Sql · 2 rows

Use case

SQL import

sql

364 B

MySQL SQL Dump

A MySQL-flavour SQL dump with backtick-quoted identifiers and engine options — for testing SQL importers.

File

SQL · Sql · 2 rows

Use case

SQL import

sql

42 B

SQL Lint Shape — Select Star Invalid

Tiny SAMPLE SQL shape (select-star-invalid) for static-analysis demos — not live DDL.

File

SQL · Sql

Use case

Code parsing/ SQL import+1· Conversion set

sql

54 B

SQL Lint Shape — Missing Where Update

Tiny SAMPLE SQL shape (missing-where-update) for static-analysis demos — not live DDL.

File

SQL · Sql

Use case

Code parsing/ SQL import+1· Conversion set

sql

124 B

SQL Lint Shape — Order By Injection Shape

Tiny SAMPLE SQL shape (order-by-injection-shape) for static-analysis demos — not live DDL.

File

SQL · Sql

Use case

Code parsing/ SQL import+1· Conversion set

sql

68 B

SQL Lint Shape — Implicit Cross Join

Tiny SAMPLE SQL shape (implicit-cross-join) for static-analysis demos — not live DDL.

File

SQL · Sql

Use case

Code parsing/ SQL import+1· Conversion set

sql

76 B

SQL Lint Shape — Drop Table Comment

Tiny SAMPLE SQL shape (drop-table-comment) for static-analysis demos — not live DDL.

File

SQL · Sql

Use case

Code parsing/ SQL import+1· Conversion set

sql

74 B

SQL Lint Shape — Union All Dupes

Tiny SAMPLE SQL shape (union-all-dupes) for static-analysis demos — not live DDL.

File

SQL · Sql

Use case

Code parsing/ SQL import+1· Conversion set