-
Notifications
You must be signed in to change notification settings - Fork 15
Insert
Ujjwal Gupta edited this page Oct 24, 2019
·
5 revisions
insert into TABLE_NAME ({column1:value1,column2:value2,...});
e.g -
INSERT INTO CUSTOMERS ("{ID:1,NAME:'Ramesh',AGE:32,ADDRESS:'Ahmedabad',SALARY:2000}");
Get Inserted Record Value (Helpful when using autoIncrement & need inserted autoIncrement column value)
add option return in last of query
e.g -
INSERT INTO CUSTOMERS ("{ID:1,NAME:'Ramesh',AGE:32,ADDRESS:'Ahmedabad',SALARY:2000} return");