How to Post 1 Lakh rows into table very fast
How to Insert 1 lakh rows into the below table from a file
CREATE TABLE icet(
id decimal(10,0) NOT NULL,
name varchar(100) NOT NULL,
rank decimal(10,0) NOT NULL,
PRIMARY KEY (id));
The Sample Data in the Table is in the below format :
3003308,GANNAVARAPU GOPALA KRISHNA MURTHY,1
3398122,SHAIK ALLAUDDIN,2
.....
....