MySQL support (DML)

[nene]

DML Statements

• [x] INSERT
  • [x] basic syntax
  • [x] without INTO
  • [x] DEFAULT values
  • [x] LOW_PRIORITY, DELAYED, HIGH_PRIORITY, IGNORE modifiers
  • [x] PARTITION clause
  • [x] INSERT ... SELECT
  • [x] INSERT ... TABLE
  • [x] VALUE / VALUES
  • [x] ROW constructors
  • [x] INSERT ... SET
  • [x] AS row_alias (col_alias, ...)
  • [x] ON DUPLICATE KEY UPDATE
• [x] DELETE
  • [x] basic syntax
  • [x] LOW_PRIORITY, QUICK, IGNORE modifiers
  • [x] table alias
  • [x] PARTITION clause
  • [x] optional WHERE clause
  • [x] ORDER BY clause
  • [x] LIMIT clause
  • [x] USING clause
  • [x] multiple tables
  • [x] tbl.* syntax
• [x] UPDATE
  • [x] basic syntax
  • [x] LOW_PRIORITY, IGNORE modifiers
  • [x] Default values
  • [x] ORDER BY clause
  • [x] LIMIT clause
  • [x] multi-table support
• [x] REPLACE
  • [x] works exactly as INSERT
• [x] TRUNCATE TABLE