# 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

Notation: UPPERCASE words are SQL keywords. [square brackets] enclose optional elements. ",..." follows an item that can be repeated in a comma-separated list. {curly braces} group elements for use with ",..." or |. | (vertical bar) separates alternatives. Italic words stand for something the user supplies.