SQL Basics

-- # single-line comment
/* comment */ # multi-line comment

SELECT * FROM users; # select all columns
SELECT name, email FROM users; # specific columns

SELECT * FROM users WHERE age > 18; # filter rows

SELECT * FROM users ORDER BY name; # sort ascending
SELECT * FROM users ORDER BY age DESC; # sort descending

INSERT INTO users (name, email)
VALUES ('John', '[email protected]'); # insert row

UPDATE users SET age = 26 WHERE id = 1; # update row

DELETE FROM users WHERE id = 1; # delete row

SELECT * FROM users LIMIT 10; # limit results