Insert and Select Query in MYSQL by R4R Team

What is insertion in Table?
Basically, after creating structure of the table , we have to insert data into the table. So for insertion we have to run following query:

Syntax:
INSERT INTO table_name(column1,column2,...) values(value1,value2,...)

We have a empty employee table:

SELECT * FROM employee;

emp_id emp_name department emp_salary

INSERT INTO student values(1,"Aman",D1,34000);
INSERT INTO student values(2,"Ram",D2,43000);
INSERT INTO student values(3,"Ramesh",D1,2000);
INSERT INTO student values(4,"John",D3,65000);
INSERT INTO student values(5,"Sita",D1,10000);
INSERT INTO student values(6,"Dinesh",D2,15000);


SELECT * FROM employee;

emp_id emp_name department emp_salary
1 Aman D1 34000
2 Ram D2 43000
3 Ramesh D1 20000
4 John D3 65000
5 Sita D1 10000
6 Dinesh D2 15000


Leave a Comment: