Data · 7 files
Sample SQL Files
SQL dumps with a CREATE TABLE statement and batched INSERTs for 100 or 10,000 rows. They use portable SQL that loads in PostgreSQL, MySQL and SQLite.
All 7 SQL files
Download all with curl
# 7 files, 131 MB in total
while read -r url; do curl -LO --fail "$url"; done <<'EOF'
https://files.samplefiles.com/data/sql/sample-100-rows.sql
https://files.samplefiles.com/data/sql/sample-1k-rows.sql
https://files.samplefiles.com/data/sql/sample-1mb.sql
https://files.samplefiles.com/data/sql/sample-10k-rows.sql
https://files.samplefiles.com/data/sql/sample-10mb.sql
https://files.samplefiles.com/data/sql/sample-100k-rows.sql
https://files.samplefiles.com/data/sql/sample-100mb.sql
EOF| File | Size | Details | Download |
|---|---|---|---|
| SQL dump, 100 rowssample-100-rows.sql | 18.6 KB | 100 rows | Download |
| SQL dump, 1,000 rowssample-1k-rows.sql | 183 KB | 1,000 rows | Download |
| 1 MB SQL filesample-1mb.sql | 1023 KB | 4,836 rows | Download |
| SQL dump, 10,000 rowssample-10k-rows.sql | 1.8 MB | 10,000 rows | Download |
| 10 MB SQL filesample-10mb.sql | 9.9 MB | 47,958 rows | Download |
| SQL dump, 100,000 rowssample-100k-rows.sql | 18.3 MB | 100,000 rows | Download |
| 100 MB SQL filesample-100mb.sql | 99.9 MB | 475,240 rows | Download |