0

How to Insert values into tables?

syntax INSERT into table name values(column1,column2,column3,column4); for example INSERT into customers values(1,'Dipayan','Pramanik','India');

20th Aug 2016, 7:24 PM
Dipayan Pramanik
Dipayan Pramanik - avatar
1 Odpowiedź
+ 1
An alternative : INSERT INTO tablename(columname1, columnname4) VALUES(valueforcolumn1, valueforcolumn4) In this manner, the columns 2 and 3 could be omitted case their not required.
21st Aug 2016, 12:52 AM
felipecvlh