Andrew Greensted (Modified: 25 July 2007)
Web > SQL

SQL

A crib sheet for SQL stuff

Common SQL Queries

• Common SQL Queries

Below are some common SQL queries.

CREATE TABLE members (name TEXT, email TEXT, age int);
INSERT INTO members VALUES ('bob', 'bob@example.com', '94');
INSERT INTO members (name, age, email) VALUES ('fred', 'fred@example.com', '45');
UPDATE ONLY members SET age='54', email='f.smith@example.com' WHERE name='fred';
GRANT SELECT,UPDATE,INSERT,DELETE ON members TO adminUser;

Select only the first 5 rows:

SELECT * FROM members LIMIT 5;