CODEWITHSUNDEEP
mysqlbulkinsertload-data-infile
Ashok
Ashok

Reputation:

MySQL Query, bulk insertion

I have a bulk data for insertion in MYSQL Tables, let use suppose, 10k in one time, What I am doing is store the data in an XML file and then go for insertion (data is around 50K rows), It will take a lot of time, Is there any option for bulk insertion in MySQL tables.

Thanks in advance,
Please help.

Upvotes: 0

Views: 1151

Answers (2)

Cesar
Cesar

Reputation: 1610

You may also want to disable de indexes before insertion and enable them afterwards to recreate them.

ALTER TABLE ... DISABLE
ALTER TABLE ... ENABLE KEYS

Upvotes: 0

Learning
Learning

Reputation: 8175

LOAD DATA INFILE can help. It is the fastest way to load data from text file.

Upvotes: 3

Related Questions