• Definition :

This statement is used to add new record/s into the database table.

  • Syntax :

INSERT INTO table-name (column-name1, column-name2, column-name3, column-name4, column-name5 VALUES (value1, value2, value3, value4, value5 );

  • Example 1 :
INSERT INTO employee (emp_id, emp_name, emp_addr, emp_dept, emp_dob, emp_sal, emp_mob) VALUES ("105M", "Rohit", "Mumbai", "Manager", "05/22/2020" 17500, 9334582186);
-------------------------------------------------------------
INSERT INTO employee (emp_id, emp_name, emp_addr, emp_dept, emp_dob, emp_sal, emp_mob) VALUES ('105M', 'Rohit', 'Mumbai', 'Manager', '05/22/2020' 17500, 9334582186);

 354 total views,  1 views today

Categories: SQL

0 Comments

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.