I'm not sure I understand where the other field data (that you say you have
to enter manually) is coming from, but what I often do when confronted with
data that needs to be massaged before entry is put it in an Excel
spreadsheet and use a formula to build the MySQL statements.
Regards,
Jerry Sc
I don't know; never tried it that way
_
From: axis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 9:37 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: What's the best way to INSERT a long list of email addresses
and names into a TABLE?
HT
Presuming your csv is set up in the structure of your table - this may help
BULK INSERT tablename
FROM 'C:\filelocation\my_data.csv'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR ='\n'
)
I am going through a SQL class and this is the method we are using to bulk