插入数据

插入完整的行

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;

 

转载于:https://www.cnblogs.com/xjyxp/p/11162569.html