LearnSQL

by Raresh Nistor

JavaScript WarningJavaScript is either disabled or hasn't loaded yet. LearnSQL runs entirely client-side and needs it to run.If you are unsure about running JavaScript and want to audit the code first, you can download this project from GitHub.

Query Error

Query Response

Reference

Below are example queries you can try:

SELECT * FROM Cats
SELECT Name, Color FROM Cats
SELECT * FROM Cats WHERE Color = "Tabby"
SELECT * FROM Cats WHERE Birth > 2000
SELECT * FROM Cats WHERE Color IS NULL

INSERT INTO Cats VALUES ("Paddles", 2016, 0, "Ginger")
INSERT INTO Cats (Name, Birth) VALUES ("Schrödinger", 1935)

UPDATE Cats SET Alive = 0 WHERE Birth < 1977
DELETE FROM Cats WHERE Alive != 1

Database View

About LearnSQL

LearnSQL is a client-side database system for people interested in SQL to get their head around the idea of tables and the syntax commonly used with relational databases.

This website uses sql.js, a port of SQLite to WebAssembly for the database backend. Also, heads-up: once you refresh, the changes you've made will be lost.

Made by Raresh Nistor · GitHub