Insert query using excel

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……..!!!

705 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.