Suppose, my csv file contains
"item_name","price","description"
mobile,500$,It has many features (e.g., camera, big display, etc)
I want to load this csv data file in mysql database using mysql command like
load data local infile 'file.csv' into table table
fields terminated by ','
lines terminated by '\n'
(column1, column2, column3,...)
You can also say to use enclosing each value by "
and using enclosed by '"'
option of mysql. But enclosing each value is overhead to me.
I can enclose only description
value if there is a solution to read this type of csv where one column is enclosed by "
but not all.