List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:October 15 2009 3:39pm
Subject:Re: Inserting csv
View as plain text  
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
<biz@stripped> 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=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!

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