3.1. INSERT
Insert is use for add a single or multiple record in a table.
QUERY: - INSERT INTO tbname(column1,column2…)VALUES (data1,data2…);
EXAMPLE: - INSERT INTO employee
(emp_id , f_name , salary , date_of_joining)
VALUES
(1,’Ravi’,25000,’2018-12-23’);
If you give any column as a identity then you will not insert detail of that column.
If you want to insert multiple record at a time then write this query
QUERY :- INSERT INTO tbname (column1,column2…)VALUES (data1,data2…), (data1,data2…),(data1,data2…);
NOTE :- if you enter any string in table then write this string in a ‘Single Quotes’. Use Single Quotes for date as well.
Last modified: Monday, 2 December 2019, 12:17 PM