• Examples
  • Sample Database
#1
CREATE TABLE people (
	first_name text NOT NULL,
	last_name text NOT NULL
);
#2
INSERT INTO people (first_name, last_name)
VALUES
	('John', 'Doe');
#3
SELECT
	rowid,
	first_name,
	last_name
FROM
	people;
#4
DROP TABLE people;

CREATE TABLE people (
	person_id INTEGER PRIMARY KEY,
	first_name text NOT NULL,
	last_name text NOT NULL
);
#5
INSERT INTO people (
	person_id,
	first_name,
	last_name
)
VALUES
	(
		9223372036854775807,
		'Johnathan',
		'Smith'
	);
#6
INSERT INTO people (
	first_name,
	last_name
)
VALUES
	(
		'William',
		'Gate'
	);
#7
DROP TABLE people;

CREATE TABLE people (
	person_id INTEGER PRIMARY KEY AUTOINCREMENT,
	first_name text NOT NULL,
	last_name text NOT NULL
);
#8
INSERT INTO people (
	person_id,
	first_name,
	last_name
)
VALUES
	(
		9223372036854775807,
		'Johnathan',
		'Smith'
	);
#9
INSERT INTO people (
	first_name,
	last_name
)
VALUES
	(
		'John',
		'Smith'
	);
albums artists customers employees genres invoice_items invoices media_types playlist_track playlists tracks
  • SQL Query
Enter a query, then click the execute button or press F9 to run it.
  • Result
Loading