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
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
Download from the command line
curl -L -o sample-1mb.sql https://files.samplefiles.com/data/sql/sample-1mb.sqlwget https://files.samplefiles.com/data/sql/sample-1mb.sqlhttps://files.samplefiles.com/data/sql/sample-1mb.sqlprintf '%s %s\n' d9bf6520d609380209472fe7e77724efdf24dce3dd4c32c1e710505a40d3c353 sample-1mb.sql | shasum -a 256 -cOr 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
| 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 |
| 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 |