Structured Query Language

SQL is the standard language for relational databases. SELECT, INSERT, UPDATE, DELETE — and the all-important JOIN.

SELECT

SELECT * FROM users WHERE active = 1;

JOIN

SELECT o.id, u.name FROM orders o JOIN users u ON u.id = o.user_id;

Related articles