kmurphychi
asked on
Trouble import csv into MYSQL
I keep getting an Invalid Column count on line 1 when I try to import data into MYSQL into an existing table. I know there are the correct number of columns. If I escape the lines with \r the data will import, but it will add \r to the last column so that in the database the data shows up as full_html\r instead of full_html
not sure what I am doing wrong but I have attached a sample of the data that i am trying to import. Any help would be hugely appreciated. Not sure if it makes a difference but I am on a mac. Been working on this for days with no luck.
not sure what I am doing wrong but I have attached a sample of the data that i am trying to import. Any help would be hugely appreciated. Not sure if it makes a difference but I am on a mac. Been working on this for days with no luck.
no attachment that I can see ... !?
What are you importing with
Custom PHP Script
PHPMyAdmin
SQLYog
?
Custom PHP Script
PHPMyAdmin
SQLYog
?
ASKER
That's weird. I thought it attached. Here it is. Thanks!
sampleimportdataL.csv
sampleimportdataL.csv
ASKER
I'm importing through PHPMyAdmin.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANK YOU!!!!! Removing the extra , worked like a charm!
Excellent! Glad to help.