1--sql insert quest example
2INSERT INTO table_name (column1, column2, column3, ...)
3VALUES (value1, value2, value3, ...);
1
2//to insert value
3INSERT INTO students VALUES (200, 'Jones', 101);
4INSERT INTO students VALUES (201, 'Smith', 101);
5INSERT INTO students VALUE (202, 'Lee' , 102);
1INSERT INTO agentbangalore
2SELECT * FROM agents
3WHERE working_area="Bangalore";
4