SQL · 1023 KB

1 MB SQL file

A SQL dump with 4,836 INSERT statements. Sized just under 1 MB (1,048,531 bytes) for upload-limit and performance tests.

CC0 · free for any use · Verified by an independent tool · Report a problem

sample-1mb.sql — first linesSQL
CREATE TABLE customers (id INTEGER PRIMARY KEY, first_name TEXT, last_name TEXT, email TEXT, phone TEXT, company TEXT, job_title TEXT, city TEXT, country TEXT, signup_date DATE, balance REAL, active BOOLEAN);
INSERT INTO customers VALUES (1, 'Eric', 'Allen', '[email protected]', '+1-452-555-0134', 'Wilson-Carlson', 'Forensic scientist', 'North Randall', 'Mauritania', '2021-08-19', 18218.51, TRUE);
INSERT INTO customers VALUES (2, 'John', 'Payne', '[email protected]', '+1-603-555-0199', 'Ferrell-Henry', 'Professor Emeritus', 'Lake Paulborough', 'Rwanda', '2021-04-02', 21705.75, TRUE);
INSERT INTO customers VALUES (3, 'Jeffery', 'Miller', '[email protected]', '+1-353-555-0120', 'Wagner, Walker and Roberts', 'Veterinary surgeon', 'Wolffort', 'Angola', '2023-09-21', 6520.92, TRUE);
INSERT INTO customers VALUES (4, 'Monique', 'Bates', '[email protected]', '+1-228-555-0110', 'King and Sons', 'Scientist, water quality', 'West Regina', 'Cook Islands', '2024-10-15', 24438.99, TRUE);
INSERT INTO customers VALUES (5, 'Ashley', 'Gonzalez', '[email protected]', '+1-792-555-0175', 'Tate LLC', 'Pension scheme manager', 'Courtneyfort', 'Puerto Rico', '2022-01-15', 4120.55, TRUE);
INSERT INTO customers VALUES (6, 'Mitchell', 'Pena', '[email protected]', '+1-477-555-0157', 'Wilkerson-Ayala', 'Engineer, automotive', 'Yvonnebury', 'Wallis and Futuna', '2022-09-19', 19855.17, TRUE);
INSERT INTO customers VALUES (7, 'Tricia', 'Taylor', '[email protected]', '+1-487-555-0115', 'Miller-Orr', 'Legal executive', 'Kevinfort', 'British Virgin Islands', '2024-02-25', 10002.66, TRUE);
INSERT INTO customers VALUES (8, 'Megan', 'Mcmillan', '[email protected]', '+1-901-555-0121', 'Foley Inc', 'Community development worker', 'West Angelashire', 'Peru', '2022-07-21', 7392.88, TRUE);
INSERT INTO customers VALUES (9, 'Wendy', 'Cortez', '[email protected]', '+1-685-555-0150', 'Rivera-Carter', 'Therapist, horticultural', 'West Williamshire', 'Andorra', '2024-11-07', 15191.85, TRUE);
INSERT INTO customers VALUES (10, 'Brandon', 'Fitzpatrick', '[email protected]', '+1-785-555-0156', 'Watson Group', 'Astronomer', 'Larryside', 'Singapore', '2022-04-10', 23570.27, TRUE);

File details

Size
1023 KB (1,048,531 bytes)
MIME type
application/sql
Rows
4,836
SHA-256
d9bf6520d609380209472fe7e77724efdf24dce3dd4c32c1e710505a40d3c353
MD5
0f99e0c99103548790c36a099b94d2d2

Download from the command line

curl -L -o sample-1mb.sql https://files.samplefiles.com/data/sql/sample-1mb.sql

Or check the download in your browser with the checksum calculator.

Same sample in other formats

JSON · 1023 KBXML · 1023 KBNDJSON · 1023 KBYAML · 1023 KBSQLite · 1 MBParquet · 998 KB

Similar SQL files

FileSizeDetailsDownload
SQL dump, 100 rowssample-100-rows.sql18.6 KB100 rowsDownload
SQL dump, 1,000 rowssample-1k-rows.sql183 KB1,000 rowsDownload
SQL dump, 10,000 rowssample-10k-rows.sql1.8 MB10,000 rowsDownload
10 MB SQL filesample-10mb.sql9.9 MB47,958 rowsDownload
SQL dump, 100,000 rowssample-100k-rows.sql18.3 MB100,000 rowsDownload
100 MB SQL filesample-100mb.sql99.9 MB475,240 rowsDownload