Features

From Hashmysql
Jump to: navigation, search

Misinformation, simple ignorance and sometimes merely laziness conspire to cloud the issue of what features MySQL supports, or will support. Here are some common ones:

  • Transactions
    • Supported via the InnoDB storage engine since approximately April 2001.
  • Foreign Keys
    • Supported via the InnoDB storage engine since November 2001.
  • Unions and multi-table updates/deletes
    • Introduced in MySQL 4.0.
  • Subqueries
    • Introduced in MySQL 4.1.
  • GIS (spatial) queries
    • Introduced in MySQL 4.1.
  • Unicode and fine-grained character set/collation support
    • Introduced in MySQL 4.1.
  • SQL Stored Procedures and Functions
    • Introduced in MySQL 5.0.
  • Views
    • Introduced in MySQL 5.0.
  • Triggers
    • Introduced in MySQL 5.0.