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)

User Comments
In addition to the restrictions noted above, CSV tables can not have any auto-increment fields.
Add your own comment.