Tables Using CSV Storage Engine in MySQL

Q

How To Create a New Table Using the CSV Storage Engine in MySQL?

✍: FYIcenter.com

A

CSV (Comma-Separated Values) storage engine stores table data in text files in comma-separated value format.

CSV is not the default storage engine. You need to specify "ENGINE = CSV" at the end of the "CREATE TABLE" statement to create new tables with the CSV storage engine. The tutorial exercise below shows you a good example:

>cd \mysql\bin
>mysql -u dev -piyf fyi

mysql> CREATE TABLE fyi_csv (
  id INTEGER PRIMARY KEY,
  title VARCHAR(80), 
  count INTEGER )
  ENGINE = CSV;
Query OK, 0 rows affected, 1 warning (0.07 sec)

mysql> SHOW CREATE TABLE fyi_csv;
  CREATE TABLE `fyi_csv` (
  `id` int(11) NOT NULL,
  `title` varchar(80) default NULL,
  `count` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 
1 row in set (0.02 sec)

Apparently, the CSV storage engine is not supported in "mysqld-max" version of the MySQL server. You need to recompile MySQL server from source with the "--with-csv-storage-engine" option.

 

Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇒⇒MySQL Database Tutorials

2017-08-13, 300👍, 0💬