Database: SQL: Commands

SELECT ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY ...

See SELECT summary.

CREATE TABLE table-name ...

Creates a table. See Table Commands.

DROP TABLE table-name ...

Removes a table from the database. See Table Commands.

ALTER TABLE table-name ...

Adds, deletes, or alters columns. See Table Commands.

INSERT INTO table-name [(column-name),...]
    {VALUES (constant,...)} | query

If the query form is used, it can insert multiple rows. The query is a SELECT statement.

UPDATE table-name
    SET {col-name = expression},...
    WHERE search-condition