MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

18.4.2 CSV Limitations

The CSV storage engine does not support indexing.

The CSV storage engine does not support partitioning.

All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.

MySQL Documentation Library