BULK INSERT in MYSQL

Question

On MS SQL, I can do bulk insert using the sql command below:

BULK INSERT myDatabase.MyTable FROM 'C:\MyTextFile.txt' WITH FIELDTERMINATOR = ','

Now I want to do the same on MySQL but I can't seem to figure out how this works and what query to use.

Eric J. · Accepted Answer · 2013-01-15 02:45:38Z

32

In MySQL, the equivalent would be

LOAD DATA INFILE

LOAD DATA INFILE 'C:\MyTextFile' INTO TABLE myDatabase.MyTable FIELDS TERMINATED BY ','

answered Jan 15, 2013 at 2:45

151k65 gold badges353 silver badges563 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

How would you do the 'ignore', as if I have a number "2,123.23" How would I ignore that comma

Thank you, here is more detailed overview of this and one more option: medium.com/@benmorel/high-speed-inserts-with-mysql-9d3dcd76f723