An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Monday, December 8, 2008

CSV - MySQL Storage Engine

No comments :
Keywords: MySQL, MySQL Storage Engines, Storage Engines, CSV Storage Engine

CSV - MySQL Storage Engine

·        CSV Storage Engine is used to deal the Database structure in CSV (Comma Separated Format).

·        Each table created using CSV Storage Engine will have to files associated to that CSV Table type:-

1.      .frm file
2.      .csv file
3.  .csm file

 ·        The .frm file of the CSV storage table will have all the table & column definitions.

·        The .csv file of the CSV storage table will have all the values in comma separated format. Initially this csv file will be empty, then if stored data in the table, .csv file will get updated automatically.

·        The .csm file of CSV storage table will have the metadata information of the table

·        This .csv file shall be opened in Ms-Excel, Star Office, Open-Office Spread Sheet, or even in a notepad to view the data presented in the table.

Notes on CSV Storage Engine:

  • CSV Storage Engine will be useful if you have the existing data in a excel or csv file and wanted to import it into a mysql TABLE
  • Edition, deletion, addition becomes very easy. Even users having no knowledge in mysql can do all these data manipulation operations.
  • CSV Storage tables doesn't support index options. This will obviously increase the response time of select statement(if provided a where clause) by making it slow.
For more information, pls visit: 

Keywords: MySQL, MySQL Storage Engines, Storage Engines, CSV Storage Engine

Featured Blog Topics:


No comments :