If you could show us the table structure (SHOW CREATE TABLE membership), we could easily correctly the query.. you seems to have some data among your field names...
If the question is about the CSV converter, you will have to ask them. - michael dykman On Thu, Oct 15, 2009 at 11:26 AM, Patrice Olivier-Wilson <b...@biz-comm.com> wrote: > 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=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats! Howard Aiken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
