Tuesday, 9 June 2020

insert into values

how to append rows
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
we can insert required column not all
INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

No comments:

Post a Comment