How to Insert Record In MYSQL

[Lost User]

Hello Experts, I have 1 Lacs Records in Excel or XML. And i want to insert those records in Live Database in single Event. So pls help me for this issue.

If you can think then I Can.

[Wayne Gaylard]

My advice would be to convert the excel/xml file to a csv file and then you can use LOAD DATA INFILE[^] syntax to upload the data. This will be much quicker than using a transaction and Insert statements, especially if you are creating indexes. See Speed of Insert Statements[^] to get an idea of what is involved. Hope this helps

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

[SilimSayo]

You know "Lacs" is not an English word... :) Always remember to say 100K or 100,000.

[Lost User]

SilimSayo wrote:

You know "Lacs" is not an English word

It is indeed an English word (although the spelling is not correct). You meant it is not American, right?

[sri080188]

u can use BULKinsert