• Examples
  • Sample Database
#1
INSERT INTO artists (name)
VALUES
	('Bud Powell');
#2
SELECT
	artistid,
	name
FROM
	artists
ORDER BY
	artistid DESC
LIMIT 1;
#3
INSERT INTO artists (name)
VALUES
	("Buddy Rich"),
	("Candido"),
	("Charlie Byrd");
#4
SELECT
	artistid,
	name
FROM
	artists
ORDER BY
	artistid DESC
LIMIT 3;
#5
INSERT INTO artists DEFAULT VALUES;
#6
SELECT
	artistid,
	name
FROM
	artists
ORDER BY
	artistid DESC;
#7
CREATE TABLE artists_backup(
	artistid INTEGER PRIMARY KEY AUTOINCREMENT,
	name NVARCHAR
);
#8
INSERT INTO artists_backup SELECT
	artistid,
	name
FROM
	artists;
#9
SELECT
	*
FROM
	artists_backup;
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