I have a problem while importing a CSV file in PhpMyAdmin. This file contains all the values that I want to insert in the database, separated by commas. When I import them I explicitly tell PhpMyAdmin that the fields are separated by commas, however, after the import is complete, the commas are part of the field too, they are not eliminated.
Example: if in the csv file I have this line:
firstvalue,secondvalue,thirdvalue,...
After the import what I have is that in the first column of the database I have the value “firstvalue,”, in the second one I have “secondvalue,” and so on, even if commas should be eliminated.
What am I doing wrong? Is there some other option in PhpMyAdmin that I’ve missed?