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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org