SQL · 1.8 MB
SQL dump, 10,000 rows
CREATE TABLE plus batched INSERT statements for 10,000 customers. Portable across PostgreSQL, MySQL and SQLite.
CC0 · free for any use · Verified by an independent tool · Report a problem
-- Sample SQL dump generated by samplefiles.com
-- 10,000 customers. Standard SQL that loads in PostgreSQL, MySQL and SQLite.
CREATE TABLE customers (
id INTEGER PRIMARY KEY,
first_name VARCHAR(100) NOT NULL,
last_name VARCHAR(100) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE,
phone VARCHAR(32),
company VARCHAR(255),
job_title VARCHAR(255),
city VARCHAR(100),
country VARCHAR(100),
signup_date DATE,
balance DECIMAL(12, 2),
active BOOLEAN
);
INSERT INTO customers (id, first_name, last_name, email, phone, company, job_title, city, country, signup_date, balance, active) VALUES
(1, 'Darrell', 'Brown', 'darrell.brown1@example.com', '+1-461-555-0115', 'Washington Group', 'Farm manager', 'South Stephanie', 'Slovenia', '2022-07-09', 11542.25, TRUE),
(2, 'Kayla', 'Gonzalez', 'kayla.gonzalez2@example.com', '+1-599-555-0155', 'Miller-Chan', 'Producer, television/film/video', 'North Davidshire', 'Jordan', '2024-04-20', -446.3, TRUE),
(3, 'Christian', 'Wright', 'christian.wright3@example.com', '+1-525-555-0103', 'Elliott-Hernandez', 'Camera operator', 'Lake Austin', 'Peru', '2023-08-23', 13306.02, FALSE),
(4, 'Marilyn', 'Watkins', 'marilyn.watkins4@mail.example.com', '+1-943-555-0103', 'Kirk-Gutierrez', 'Aeronautical engineer', 'South Crystal', 'Turkmenistan', '2024-04-13', 10666.13, TRUE),
(5, 'Heather', 'Reynolds', 'heather.reynolds5@example.org', '+1-979-555-0158', 'Hammond-Lewis', 'Computer games developer', 'Jameschester', 'Heard Island and McDonald Islands', '2022-05-02', 20858.24, TRUE),
(6, 'Devin', 'Martin', 'devin.martin6@example.net', '+1-323-555-0195', 'Winters PLC', 'Audiological scientist', 'Michaelton', 'Mali', '2025-06-16', 17635.39, FALSE),File details
Download from the command line
curl -L -o sample-10k-rows.sql https://files.samplefiles.com/data/sql/sample-10k-rows.sqlwget https://files.samplefiles.com/data/sql/sample-10k-rows.sqlhttps://files.samplefiles.com/data/sql/sample-10k-rows.sqlprintf '%s %s\n' 98af16f4fe158e259414c35551e738c13576c7bacb2dd804f96b59def012ae7f sample-10k-rows.sql | shasum -a 256 -cOr check the download in your browser with the checksum calculator.
Featured in
Same sample in other formats
SQLite · 2.9 MBParquet · 492 KBAvro · 699 KBORC · 415 KBArrow IPC · 1.6 MBFeather · 889 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 |
| 1 MB SQL filesample-1mb.sql | 1023 KB | 4,836 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 |