query: selects | dml | transaction; selects: select | union ; ddl: view | alter ; dml: update | insert ; select: SELECT select_item FROM join WHERE where_cond_2 group_by order_by limit; select_explain: EXPLAIN EXTENDED select; order_by: | ORDER BY X . field_name; group_by: | GROUP BY X . field_name; limit: | LIMIT tinyint_unsigned ; select_item: X . field_name | value | COUNT( X . field_name ) | AVG( Y . field_name ); from: table_name AS X | ( select ) AS X; where_cond_2: X . field_name < value; where_cond_1: field_name < value; insert: INSERT INTO table_name ( field_name , field_name ) VALUES ( value , value ) ; update: UPDATE table_name AS X SET field_name = value WHERE where_cond_2 ORDER BY RAND ( ) limit ; delete: DELETE FROM table_name WHERE where_cond_1 ORDER BY RAND ( ) limit; join: table_name AS X LEFT JOIN table_name AS Y ON ( X . field_name = Y . field_name ) | letter AS X LEFT JOIN table_name AS Y ON ( X . field_name = Y . field_name ); alter: ALTER TABLE table_name ADD COLUMN Z INTEGER | ALTER TABLE table_name DROP COLUMN Z | ALTER TABLE table_name ADD INDEX M ( 'int_nokey' ) | ALTER TABLE table_name DROP INDEX M ; transaction: start | end; start: START TRANSACTION; end: COMMIT | ROLLBACK; view: CREATE OR REPLACE VIEW letter AS SELECT X . * FROM join WHERE where_cond_2; union: ( select ) UNION ALL ( select ) ; value: tinyint_unsigned; letter: 'a' | 'b' | 'c' | 'd' | 'e' | 'f' | 'g' | 'h' | 'j' | 'k' ; table_name: A | B | C | D | E | F ; field_name: 'pk' | 'int_key' | 'int_nokey' ;