SQL · 9.9 MB

10 MB SQL file

A SQL dump with 47,958 INSERT statements. Sized just under 10 MB (10,485,643 bytes) for upload-limit and performance tests.

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

sample-10mb.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
9.9 MB (10,485,643 bytes)
MIME type
application/sql
Rows
47,958
SHA-256
c2ca2952622e9397c6d3f8c33a01422270f2a378b0c7427a49ce0638e54820eb
MD5
acf9260d901f54af80f3040a93116676

Download from the command line

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

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

Same sample in other formats

JSON · 9.9 MBXML · 9.9 MBNDJSON · 9.9 MBYAML · 9.9 MBSQLite · 9.6 MBParquet · 9.3 MB

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
1 MB SQL filesample-1mb.sql1023 KB4,836 rowsDownload
SQL dump, 10,000 rowssample-10k-rows.sql1.8 MB10,000 rowsDownload
SQL dump, 100,000 rowssample-100k-rows.sql18.3 MB100,000 rowsDownload
100 MB SQL filesample-100mb.sql99.9 MB475,240 rowsDownload