• HIGH_PRIORITY / LOW_PRIORITY
  • DELAYED (for insert and replace)
  • STRAIGHT_JOIN
  • SQL_SMALL_RESULT / SQL_BIG_RESULT
  • SQL_BUFFER_RESULT
  • SQL_CACHE / SQL_NO_CACHE
  • SQL_CALC_FOUND_ROWS
  • USE INDEX / IGNORE INDEX / FORCE INDEX
  • FOR UPDATE, LOCK IN SHARE MODE