CSV engine on MySQL server
- by Jeff
I don't think that this is a programming question so I am going to ask it here -
Reading the book high performance mysql, I read about the CSV engine. The paragraph says:
The CSV engine can treat comma-separated values (CSV) files as table,
but it does not support indexes on them. This engine lets you copy
files in and out of the database while the server is running. If you
export a CSV file from a spreadsheet and save it in the MySQL server's
data directory, the server can read it immediately. Similary, if you
write data to a CSV table, an external program can read it right away.
CSV tables are especially useful as a data interchange format and for
certain kinds of logging.
What I get from this paragraph is that I can copy a .CSV file into the data directory of database, and it should show as a table that is able to be read from. However, whenever I copy a test .csv file into the directory, it does not appear as a table. I can't access it.
I am using MySQL 5.5 also
Does anyone know why this is not working, or what I am doing wrong?
Thanks