Results 1 to 2 of 2
Apr 27, 2011, 08:18 #1
Import a CSV file from PhpMyAdmin
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:
What am I doing wrong? Is there some other option in PhpMyAdmin that I've missed?
May 1, 2011, 12:09 #2
Ok let me change the questions: is it possible to import one column at a time from a csv file?