插入完整的行
INSERT INTO Customers VALUES(‘1000006’, ‘Toy Land’, '123 ANY street');
插入部分行
INSERT INTO customers(cust_id, cust _name, cust_address) VALUES('10000006', 'TOY LAND', '123 ANY Street');
从一个表复制到另一个表
SELECT * INTO CustCopy FROM Customers;
INSERT INTO Customers VALUES(‘1000006’, ‘Toy Land’, '123 ANY street');
INSERT INTO customers(cust_id, cust _name, cust_address) VALUES('10000006', 'TOY LAND', '123 ANY Street');
SELECT * INTO CustCopy FROM Customers;