数据插入
INSERT语句将行插入到数据库表
最简单的方法是直接INSERT VALUE
INSERT INTO Customers
VALUES(10000006,
'Toy Land',
'123 Any Street',
'New York',
NULL);
注意:INSERT后面的INTO关键字是可选的,最好还是提供这个关键词
INSERT INTO Customers(cust_id,
cust_name,
cust_address,
cust_address,
cust_city,
cust_email)
VALUES(10000006,
'Toy Land',
'123 Any Street',
'New York',
NULL);
也可以省略某些行,但是要注意满足以下条件:该列定义为允许NULL值或表定义给出默认值
插入检索的数据
INSERT 和SELECT语句
INSERT INTO Customers(cust_id,
cust_contact,
cust_email,
cust_name,
cust_address)
SELECT cust_id,
cust_contact,
cust_email,
cust_name,
cust_address
FROM CustNew;
事实上,INSERT和SELECT不需要列名匹配
从一个表复制到另一个表
CREATE SELECT语句(在SQL SERVER可以使用SELECT INTO语句)
CREATE SELECT将数据复制到一个新表
CREATE TABLE CustCopy AS SELECT * FROM
Customers;
在SQL Server可以这么写:
SELECT * INTO CustCopy FROM Customers;