Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem Importing CSV into mySQL table
Thanks KarveR for the prompt reply! • Yes, the fields in the CSV are "" enclosed. • Yes, each field in the CSV is separated by a single ,. • How do I know if each line is a newline in windows format? There's no "/n" after each line or anything if that's what you mean. I do... -
Problem Importing CSV into mySQL table
I have a table of about 500 records and 12 columns that I have saved in a CSV file. When I try to import that file into the mySQL DB table using the import feature in mySQLFront2.2, it creates all 500 Primary keys (in auto-increment so I get 500 rows returned), and the whole string gets printed...
