|
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