MySQL - Explain how to create a new table using CSV Storage Engine

Explain how to create a new table using CSV Storage Engine.

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

- CSV is not the default storage engine. "ENGINE = CSV" at the end of the "CREATE TABLE" statement can be specified to create new tables with the CSV storage engine.

- InnoDB became the default storage engine since MySQL version 5.5.

- The InnoDB table type brings many benefits of relational database management system such as ACID transaction, referential integrity, and crash recovery.

- In previous versions, MySQL used MyISAM as the default storage engine.
MySQL - What are the system tables that store user privileges?
What are the system tables that store user privileges? - mysql.user - Stores privileges granted at the global level, mysql.db - Stores privileges granted at the database level.....
MySQL features - Explain about MySQL and its features.
MySQL features - MySQL is a relational database management system which is an open source database.....
MySQL disadvantages - What are the disadvantages of MySQL?
MySQL disadvantages - MySQL does not support a very large database size as efficiently...
Post your comment

Related Content

Follow us

▲