Insert query using excel

Step 1:Create the fields and values in the excel as like below,

Rno	Name	Department	Percentage
100	AGN	CSE	76
101	PHK	CHEM	81
102	RVS	ECE	85
103	RGN	MBA	84
104	GVS	PHD	92
105	PK	MECH	80

Step 2:Type like below to create the query for all the set of values in the excel,

insert into student_details(RNO,NAME,DEPART,PERCENT) values(100,’AGN’,’CSE’,76);

Reference image:

 

 

 

Thanks for reading this post……..!!!