1  
   2  # 'SELECT' is the most popular SQL
   3  SELECT select-list FROM table-name [ WHERE search-condition ] [ ORDER BY sort-order ] 
   4  # 3 search condition types: compare, like, null
   5  
   6  # DML : INSERT, DELETE, UPDATE 
   7  INSERT INTO table-name [ ( column-identifier,… ) ] VALUES ( column-value,… ) 
   8  DELETE FROM table-name [ WHERE search-condition ] 
   9  UPDATE table-name SET update-column,… [ WHERE search-condition ] 
  10  
  11  # DDL : Work with the schema
  12  CREATE TABLE table-name (column-definition,…) 
  13  DROP TABLE table-name 
  14  ALTER TABLE table-name { ADD add-column-set [ DROP drop-column-set ] | DROP drop-column-set } 
  15  CREATE [ UNIQUE ] INDEX index-name ON table-name ( sort-specification,… ) 
  16  DROP INDEX index-name FROM table-name 

   1  
   2  ['BIT', 'INTEGER', 'COUNTER', 'BIGINT', 'FLOAT',
   3   'TIMESTAMP', 'VARCHAR(n)', 'LONG VARCHAR']
   4  # COUNTER is an auto-incremented unsigned integer