MySQL 5.7 Release Notes
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.
User Comments
User comments in this section are, as the name implies, provided by MySQL users.
The MySQL documentation team is not responsible for, nor do they endorse, any of
the information provided here.
Posted by
David Nuttall
on
July 13, 2011
In addition to the restrictions noted above, CSV tables can not have any auto-increment fields.