Syntax

From Scratchpad

Descriptions are to be provided alongside the term, but the usage of the syntax should go on the individual pages.

Contents 1 Command-line statements (not relevant for GUI's like phpMyAdmin?) 2 Statements grouped by application 2.1 Database statements 2.2 Table statements 3 Basic commands 4 Clauses, Operators, Optional filler words?

[edit] Command-line statements (not relevant for GUI's like phpMyAdmin?)

• USE (sets default database)
• DESCRIBE (show underlying data structure of table--potentially specific to column)
• SHOW
  • ... ENGINES (which storage engines are available)
  • ... DATABASES (show list of database names on server)
  • ... TABLES (show list of table names in database)
  • ... COLUMNS (show underlying data structure of particular columns)
• SET (defines variables)

[edit] Statements grouped by application

[edit] Database statements

• ALTER DATABASE
• CREATE DATABASE
• DROP DATABASE
• SHOW DATABASES

[edit] Table statements

• ALTER TABLE
• DROP TABLE
• etc.?

[edit] Basic commands

• SELECT

• INSERT
• UPDATE
• REPLACE

[edit] Clauses, Operators, Optional filler words?

• FROM
• WHERE
• INTO, VALUES

• LIKE
• REGEXP

• ORDER BY
• GROUP BY

• ASC
• DESC