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, 1613🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...