Sample customers SQL script (100 rows)

Why test with this file

Seeds a test database in seconds, or tests SQL import and migration tooling.

What to check

After your application has processed sample-customers.sql, confirm that:

• The script runs to completion on your database engine.
• The table holds exactly 100 rows afterwards.
• Running it a second time fails cleanly on the existing table rather than duplicating rows.

How the file begins

The opening lines of sample-customers.sql, exactly as they appear in the file.

-- Sample SQL script for testing
CREATE TABLE customers (
  id INTEGER PRIMARY KEY,
  first_name VARCHAR(50) NOT NULL,
  last_name VARCHAR(50) NOT NULL,
  email VARCHAR(120) NOT NULL,
  city VARCHAR(60),
  country CHAR(2),
  signup_date DATE,
  balance DECIMAL(10,2)
);

INSERT INTO customers (id, first_name, last_name, email, city, country, signup_date, balance) VALUES (1, 'Ethan', 'Zeller', 'ethan.zeller1@example.com…
INSERT INTO customers (id, first_name, last_name, email, city, country, signup_date, balance) VALUES (2, 'Elena', 'Underhill', 'elena.underhill2@examp…

Technical details

Validated for expected format and integrity. As with any download, scan the file with your own security tools before opening it. How files are made and checked

Download from the command line and verify

Fetch the file with curl, then compare its checksum with the SHA-256 value above.

curl -o sample-customers.sql 'https://sampletestfiles.com/downloads/samples/sample-customers.sql'
sha256sum sample-customers.sql     # Linux
shasum -a 256 sample-customers.sql # macOS

On Windows, run Get-FileHash sample-customers.sql -Algorithm SHA256 in PowerShell. A matching value proves that the download is complete and unaltered.

Related files

All curated sample files