(mysql.info.gz) CSV storage engine

Info Catalog

(mysql.info.gz) ARCHIVE storage engine

(mysql.info.gz) Storage engines

(mysql.info.gz) ISAM storage engine

 
 14.8 The `CSV' Storage Engine
 =============================
 
 The `CSV' storage engine was added in MySQL 4.1.4. This engine stores
 data in text files using comma-separated-values format.
 
 To enable this storage engine, use the `--with-csv-storage-engine'
 option to `configure' when you build MySQL.
 
 When you create a `CSV' table, the server creates a table definition
 file in the database directory. The file begins with the table name and
 has an `.frm' extension.  The storage engine also creates a data file.
 Its name begins with the table name and has a `.CSV' extension.  The
 data file is a plain text file. When you store data into the table, the
 storage engine saves it into the data file in CSV format.
 
      mysql> CREATE TABLE test(i INT, c CHAR(10)) ENGINE = CSV;
      Query OK, 0 rows affected (0.12 sec)
 
      mysql> INSERT INTO test VALUES(1,'record one'),(2,'record two');
      Query OK, 2 rows affected (0.00 sec)
      Records: 2  Duplicates: 0  Warnings: 0
 
      mysql> SELECT * FROM test;
      +------+------------+
      | i    | c          |
      +------+------------+
      |    1 | record one |
      |    2 | record two |
      +------+------------+
      2 rows in set (0.00 sec)
 
 If you examine the `test.CSV' file in the database directory after
 executing the preceding statements, its contents look like this:
 
      "1","record one"
      "2","record two"
 
 The `CSV' storage engine does not support indexing.
 

Info Catalog

(mysql.info.gz) ARCHIVE storage engine

(mysql.info.gz) Storage engines

(mysql.info.gz) ISAM storage engine