Thank you for the confirmation, Andy. I appreciate your patience with
such a newbie who is just trying to learn.
Andy Wallace wrote:
I've run into similar situations w/regard to Mac vs PC CSV files,
it usually has to do with the EOL character sequence. Macs use
LF (chr(10)), while PCs use CRLF
I've run into similar situations w/regard to Mac vs PC CSV files,
it usually has to do with the EOL character sequence. Macs use
LF (chr(10)), while PCs use CRLF (chr(13)chr(10)).
andy
Patrice Olivier-Wilson wrote:
In case anyone might find this of the least interest, probably not, but
I always
In case anyone might find this of the least interest, probably not, but
I always hope to add to discussion just as part of the thank you for help.
Further work with same issues found that a file received from a PC based
client, if opened in PC environment, didn't have the same problems (so
far
evice.
-Original Message-
From: Patrice Olivier-Wilson
Sent: 15 October 2009 16:26
To: [MySQL]
Subject: Inserting csv
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 phpMyA
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, Patric
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_stre