Features

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.