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.

回答1:

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

回答2:

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

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