Collections:
Tables Using CSV Storage Engine in MySQL
How To Create a New Table Using the CSV Storage Engine in MySQL?
✍: FYIcenter.com
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.
⇒ Tables Using MEMORY Storage Engine in MySQL
⇐ Data File of BDB Storage Engine in MySQL
2017-08-13, 2110🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...