Contact MySQL  | 
Login  |  Register
The world's most popular open source database
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL Restrictions and Limitations
  • Preface and Legal Notices
  • Restrictions and Limits
  • Restrictions on Stored Programs
  • Restrictions on Server-Side Cursors
  • Restrictions on Subqueries
  • Restrictions on Views
  • Restrictions on XA Transactions
  • Restrictions on Character Sets
  • Limits in MySQL
    • Limits on Joins
    • Limits on Number of Databases and Tables
    • Limits on Table Size
    • Limits on Table Column Count and Row Size
    • Limits Imposed by .frm File Structure
    • Windows Platform Limitations
  • Restrictions and Limitations on Partitioning
    • Partitioning Keys, Primary Keys, and Unique Keys
    • Partitioning Limitations Relating to Storage Engines
    • Partitioning Limitations Relating to Functions
    • Partitioning and Table-Level Locking
  • MySQL Differences from Standard SQL
    • SELECT INTO TABLE Differences
    • UPDATE Differences
    • Foreign Key Differences
    • '--' as the Start of a Comment
  • Known Issues in MySQL
Related Documentation
MySQL 5.5 Reference Manual
MySQL 5.5 Release Notes
Download this Excerpt
PDF (US Ltr) - 256.3Kb
PDF (A4) - 258.3Kb
HTML Download (TGZ) - 50.8Kb
HTML Download (Zip) - 65.1Kb


version 5.5
8.0  current
5.7
5.6

MySQL Restrictions and Limitations

Abstract

This is the MySQL Restrictions and Limitations extract from the MySQL 5.5 Reference Manual.

For legal information, see the Legal Notices.

For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

Document generated on: 2018-04-25 (revision: 57167)


Table of Contents     [+/-]

Preface and Legal Notices
1 Restrictions and Limits
2 Restrictions on Stored Programs
3 Restrictions on Server-Side Cursors
4 Restrictions on Subqueries
5 Restrictions on Views
6 Restrictions on XA Transactions
7 Restrictions on Character Sets
8 Limits in MySQL     [+/-]
8.1 Limits on Joins
8.2 Limits on Number of Databases and Tables
8.3 Limits on Table Size
8.4 Limits on Table Column Count and Row Size
8.5 Limits Imposed by .frm File Structure
8.6 Windows Platform Limitations
9 Restrictions and Limitations on Partitioning     [+/-]
9.1 Partitioning Keys, Primary Keys, and Unique Keys
9.2 Partitioning Limitations Relating to Storage Engines
9.3 Partitioning Limitations Relating to Functions
9.4 Partitioning and Table-Level Locking
10 MySQL Differences from Standard SQL     [+/-]
10.1 SELECT INTO TABLE Differences
10.2 UPDATE Differences
10.3 Foreign Key Differences
10.4 '--' as the Start of a Comment
11 Known Issues in MySQL

HOME   NEXT
Related Documentation
MySQL 5.5 Reference Manual
MySQL 5.5 Release Notes
Download this Excerpt
PDF (US Ltr) - 256.3Kb
PDF (A4) - 258.3Kb
HTML Download (TGZ) - 50.8Kb
HTML Download (Zip) - 65.1Kb
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2018, Oracle Corporation and/or its affiliates

  • Products
  • Oracle MySQL Cloud Service
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Consulting
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2018, Oracle Corporation and/or its affiliates
Legal Policies | Your Privacy Rights | Terms of Use | Trademark Policy | Contributor Agreement |