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');