MySQL 5.1 Reference Manual  /  ...  /  CSV Limitations

14.13.2 CSV Limitations

The CSV storage engine does not support indexing.

Partitioning is not supported for tables using the CSV storage engine. Beginning with MySQL 5.1.12, it is no longer possible to create partitioned CSV tables. (See Bug #19307)

Beginning with MySQL 5.1.23, 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)

Download this Manual
User Comments
  Posted by David Nuttall on July 13, 2011
In addition to the restrictions noted above, CSV tables can not have any auto-increment fields.
Sign Up Login You must be logged in to post a comment.