Pour une description détaillée, se référer à l'URL suivant: http://tecfa.unige.ch/guides/msql/msql2/spec.htm.
CREATE
CREATE TABLE table_name ( col_name col_type [ not null ] [ , col_name col_type [ not null ] ]** ) CREATE [ UNIQUE ] INDEX index_name ON table_name ( field_name [ , field_name ] ** ) CREATE SEQUENCE ON table_name [ STEP step_val ] [ VALUE initial_val ]
DROP
DROP TABLE table_name DROP INDEX index_name FROM table_name DROP SEQUENCE FROM table_name
INSERT
INSERT INTO table_name [ ( column [ , column ]** ) ]
SELECT
SELECT [table.]column [ , [table.]column ]** FROM table [ = alias] [ , table [ = alias] ]** [ WHERE [table.] column OPERATOR VALUE [ AND | OR [table.]column OPERATOR VALUE]** ] [ ORDER BY [table.]column [DESC] [, [table.]column [DESC] ] OPERATOR can be <, >, =, <=, >=, <>, LIKE, RLIKE or CLIKE VALUE can be a literal value or a column name Where clauses may contain '(' ')' to nest conditions e.g. "where (age < 20 or age > 30) and sex = 'male'" .
DELETE
DELETE FROM table_name WHERE column OPERATOR value [ AND | OR column OPERATOR value ]** OPERATOR can be <, >, =, <=, >=, <>, LIKE, RLIKE, or CLIKE
UPDATE
UPDATE table_name SET column=value [ , column=value ]** WHERE column OPERATOR value [ AND | OR column OPERATOR value ]** OPERATOR can be <, >, =, <=, >=, <>, LIKE, RLIKE or CLIKE