INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)] VALUES (value1, value2, value3,...valueN);
INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);
INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (1, 'Ajeet', 27, 'Delhi', 20000.00); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (2, 'Akash', 25, 'Patna', 15000.00 ); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (3, 'Mark', 23, 'USA', 2000.00 ); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (4, 'Chandan', 25, 'Banglore', 65000.00 ); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (5, 'Kunwar', 26, 'Agra', 25000.00 );
INSERT INTO STUDENT VALUES (6, 'Kanchan', 21, 'Meerut', 10000.00 );
SELECT * FROM STUDENT;