MySQL 5.7 Reference Manual :: 15 Alternative Storage Engines :: 15.4 The CSV Storage Engine :: 15.4.2 CSV Limitations

« 15.4.1 Repairing and Checking CSV Tables

Section Navigation [Toggle]

15.4 The CSV Storage Engine
15.4.1 Repairing and Checking CSV Tables
15.4.2 CSV Limitations

15.4.2 CSV Limitations

The CSV storage engine does not support indexing.

Partitioning is not supported for tables using the CSV storage engine.

All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns. However, for backward compatibility, you can continue to use tables with nullable columns that were created in previous MySQL releases. (Bug #32050)

Previous / Next / Up / Table of Contents

User Comments

Posted by David Nuttall on July 13 2011 11:38pm

[Delete] [Edit]

In addition to the restrictions noted above, CSV tables can not have any auto-increment fields.

Top / Previous / Next / Up / Table of Contents