List:General Discussion« Previous MessageNext Message »
From:Patrice Olivier-Wilson Date:October 15 2009 3:26pm
Subject:Inserting csv
View as plain text  
Newbie question, please.

I have a csv file of 950 records, 20 fields.

I used this converter
http://csv2sql.evandavey.com/

and copied/pasted insert code into SQL in phpMyAdmin

and got this error


SQL query:

INSERT INTO membership(  `members_ID` ,  `updated` ,  `notes` ,  
`preferred_mail_street` ,  `preferred_mail_csz` ,  `first_name` ,  
`last_name` ,  `street` ,  `city` ,  `state` ,  `zip` ,  `location_code` 
,  `property` ,  `camp_street` ,  `camp_city` ,  `camp_zip` , 
`member_year` ,  `director` ,  `email` ,  `camp_phone` ,  `20` ,  `21` 
,  `22` ,  `23` )
VALUES (

'',  '',  '',  '',  '',  'xxx',  'xxxx',  '102 Summer St',  
'Dover-Foxcroft',  'xx',  '04426',  'B',  'M15_L1_S20',  'Mill Brook',  
'Bowerbank',  '',  '',  '',  '',  '',  '',  '',  '',  ''
);

MySQL said:

#1054 - Unknown column '20' in 'field list'

Actually the first time, it was column 21, so to trouble shoot, I removed that column from
csv file and field name in phpMyAdmin.


camp_phone should be the last field but 

 `20` ,  `21` ,  `22` ,  `23` ) 

is there too... 

Any assistance most appreciated!

I checked the file and didn't see any odd entries after the camp_phone field.





-- 
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com

Thread
Inserting csvPatrice Olivier-Wilson15 Oct
  • Re: Inserting csvMichael Dykman15 Oct
RE: Inserting csvJohn Daisley15 Oct