MySQL support (DML)

[nene]

DML Statements

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