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
Hi,
I have a long list of email addresses, and names in a text file in csv
format, and I want to know what's the best approach to quickly INSERT
them into my customers TABLE.
Initially I thought it could be easy to just add SQL INSERTs to the
database dump but, the problem is I have to
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
I have a long list of email addresses, and names in a text file in csv
format, and I want to know what's the best approach to quickly INSERT
them into my customers TABLE.
Initially I thought it could be easy to just add SQL INSERTs to the
database dump but, the problem is I have to manually add
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?
