SQL · 183 KB

SQL dump, 1,000 rows

CREATE TABLE plus batched INSERT statements for 1,000 customers. Portable across PostgreSQL, MySQL and SQLite.

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

sample-1k-rows.sql — first linesSQL
-- Sample SQL dump generated by samplefiles.com
-- 1,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', '[email protected]', '+1-461-555-0115', 'Washington Group', 'Farm manager', 'South Stephanie', 'Slovenia', '2022-07-09', 11542.25, TRUE),
  (2, 'Kayla', 'Gonzalez', '[email protected]', '+1-599-555-0155', 'Miller-Chan', 'Producer, television/film/video', 'North Davidshire', 'Jordan', '2024-04-20', -446.3, TRUE),
  (3, 'Christian', 'Wright', '[email protected]', '+1-525-555-0103', 'Elliott-Hernandez', 'Camera operator', 'Lake Austin', 'Peru', '2023-08-23', 13306.02, FALSE),
  (4, 'Marilyn', 'Watkins', '[email protected]', '+1-943-555-0103', 'Kirk-Gutierrez', 'Aeronautical engineer', 'South Crystal', 'Turkmenistan', '2024-04-13', 10666.13, TRUE),
  (5, 'Heather', 'Reynolds', '[email protected]', '+1-979-555-0158', 'Hammond-Lewis', 'Computer games developer', 'Jameschester', 'Heard Island and McDonald Islands', '2022-05-02', 20858.24, TRUE),
  (6, 'Devin', 'Martin', '[email protected]', '+1-323-555-0195', 'Winters PLC', 'Audiological scientist', 'Michaelton', 'Mali', '2025-06-16', 17635.39, FALSE),

File details

Size
183 KB (188,285 bytes)
MIME type
application/sql
Rows
1,000
SHA-256
accee5cd7f2a1d67528ef17f7ca2d234dfcd7331e4f994de04495d1c904e924f
MD5
3545cb33d363eba79d89728a0685f527

Download from the command line

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

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

Same sample in other formats

SQLite · 328 KBParquet · 74.7 KBAvro · 70.2 KBORC · 48.6 KBArrow IPC · 167 KBFeather · 101 KB

Similar SQL files

FileSizeDetailsDownload
SQL dump, 100 rowssample-100-rows.sql18.6 KB100 rowsDownload
1 MB SQL filesample-1mb.sql1023 KB4,836 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