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, 1643🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...