SQL INSERT INTO 关键字
INSERT INTO
INSERT INTO
命令用于在表中插入新行。
下面的 SQL 在 "Customers" 表中插入新记录:
实例
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');
以下 SQL 将插入新记录,但仅是 "CustomerName", "City", 和 "Country"列(CustomerID 将自动更新):
实例
INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');