Sample MySQL SQL File

Q: What MySQL-specific syntax does this file use?

MySQL-specific features include: AUTO_INCREMENT, ENGINE=InnoDB, backtick quoting for identifiers, and MySQL data types (INT, VARCHAR, DATETIME). Not directly compatible with PostgreSQL or SQLite.

Download a free MySQL SQL dump with 3 tables and 1,000 rows (50 KB). Test MySQL imports, mysqldump compatibility, database seeding scripts, and MySQL-specific syntax handling.

sample-mysql.sql

55.6 KB

1,000 rows

Download

File details and verification

Filename: sample-mysql.sql
Exact size: 56,910 bytes
Displayed size: 55.6 KB
Catalog status: Valid catalog fixture
SHA-256: 3feac5727e2d7f9a7fbaf226f293db7fc0c0c2d7961974d4869d9316603edccd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-mysql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Other SQL files

sample-postgresql.sql

55.3 KB

1,000 rows

Download

File details and verification

Filename: sample-postgresql.sql
Exact size: 56,651 bytes
Displayed size: 55.3 KB
Catalog status: Valid catalog fixture
SHA-256: 9bd034cdb1452aefe78a9b94bdb353161ef4bd9abf183adedcddd612ac545cee
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-postgresql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-sqlite.sql

55.2 KB

1,000 rows

Download

File details and verification

Filename: sample-sqlite.sql
Exact size: 56,490 bytes
Displayed size: 55.2 KB
Catalog status: Valid catalog fixture
SHA-256: 15f0df10b8d315589cf5ebe044621c6a96e52ff3ae8b43e41063ca7515f326ad
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-sqlite.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-users-table.sql

28.1 KB

500 rows

Download

File details and verification

Filename: sample-users-table.sql
Exact size: 28,735 bytes
Displayed size: 28.1 KB
Catalog status: Valid catalog fixture
SHA-256: aad074e827941c55db90b7c118b96a544f3a84518cb2a7ab075a3b66bfbdb386
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 500
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-users-table.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-ecommerce.sql

245 KB

5,000 rows

Download

File details and verification

Filename: sample-ecommerce.sql
Exact size: 250,844 bytes
Displayed size: 245 KB
Catalog status: Valid catalog fixture
SHA-256: b6f6e4b4711ad979f21fa4ef0e3e7f4603c22f44156114e4373c27425b25eebd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 5,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-ecommerce.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-blog.sql

228 KB

2,000 rows

Download

File details and verification

Filename: sample-blog.sql
Exact size: 233,739 bytes
Displayed size: 228 KB
Catalog status: Valid catalog fixture
SHA-256: 219a3fa539ba2c1d78b9bbd21605b8c863ac9b23cae396354387d0b1a5c2f12b
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 2,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-blog.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-schema-only.sql

528 B

Download

File details and verification

Filename: sample-schema-only.sql
Exact size: 528 bytes
Displayed size: 528 B
Catalog status: Valid catalog fixture
SHA-256: 6b773f0fba36b6484ea5c24126a1c861427e080924d2228a77cef4542de17e2a
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-schema-only.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Frequently Asked Questions

How do I import this SQL file into MySQL?

CLI: mysql -u root -p database_name < sample-mysql.sql. Or use phpMyAdmin, MySQL Workbench, or DBeaver's import feature. The file includes CREATE TABLE and INSERT statements.

What MySQL-specific syntax does this file use?

MySQL-specific features include: AUTO_INCREMENT, ENGINE=InnoDB, backtick quoting for identifiers, and MySQL data types (INT, VARCHAR, DATETIME). Not directly compatible with PostgreSQL or SQLite.

Other data formats

JSON XML CSV Excel (XLSX)

Similar files in other formats

sample-simple.json

87 B

1 rows

Download

File details and verification

Filename: sample-simple.json
Exact size: 87 bytes
Displayed size: 87 B
Catalog status: Valid catalog fixture
SHA-256: 2ed7134796dcc9670f375f725f09c73fd518f6d2e463dd31081137a4bd068235
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/json
Rows: 1
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/json/sample-simple.json

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-simple.xml

153 B

Download

File details and verification

Filename: sample-simple.xml
Exact size: 153 bytes
Displayed size: 153 B
Catalog status: Valid catalog fixture
SHA-256: c329bdea7bc82f57371d383f658c7dde4ecf4cac01c8be1662271ff075c9f4c2
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/xml
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/xml/sample-simple.xml

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1kb.yaml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.yaml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 2e383ce376f7cdea9bc326b12d679a226657fff5a9e1f99cda389caa956f5863
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/yaml/sample-1kb.yaml

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1kb.toml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.toml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 5321484b28dd4dd11e150116a8e70e97e8d5d953bb38a6340a13766822d35faf
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/toml/sample-1kb.toml

See how TrueFileSize generates and measures sample files, or review the editorial policy.