I need to import a database (currently in excel) to Mysql. I searched a little and found out that CSV files can be imported. However, there is a problem that I am facing. The delimiter for fields in a CSV is a ',' obviously. But many of the fields in my excel database are longtext which have commas.
I'd really appreciate if somebody could tell me how I can resolve this problem and import the data seamlessly without having to enter a 14 Mb file manually.