One of the most things that I liked about MySQL RDBMS is, It supported different types of Storage Engine for different types of requirement.
I have also published one related article, How to import and export CSV data in MySQL.
Additionally, MySQL has a wonderful CSV (Comma Separated Value) storage engine to store table data directly into CSV file.
When you create any table with CSV storage engine, It creates table_name.frm file and table_name.csv file into /../MySQL/Data/Database directory.
You can easily open that table_name.csv file and You can also SELECT that CSV table data using MySQL Query Window.
Few Important Points:
CSV storage engine does not support NULL columns, all columns must be NOT NULL.
CSV storage engine does not support any type of Indexing.
CSV storage engine does not support Table Partitioning.
Create a sample table using CSV Stroage Engine:
CREATE TABLE tbl_Students
RNO INT NOT NULL
,StudName VARCHAR(20) NOT NULL
)ENGINE = CSV;
Insert few records:
INSERT INTO tbl_Students
Check the result of table and also check .csv file which is created in /../MySQL/Data/Database directory.
SELECT *FROM tbl_Students;
| RNO | StudName |
| 1 | Anvesh |
| 2 | Neevan |
| 3 | Jeeny |
| 4 | Roy |
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.