如何从其他表中插入多个选定的行值到新表
问题描述:
从一个查询是否可以做到?如何从其他表中插入多个选定的行值到新表
要从一个表中插入多个选定的行信息到其它的表 像:
Customers (register_no,CustomerName, City, Country)
Suppliers(register_no,SupplierName, City, Country)
INSERT INTO Customers (register_no,CustomerName, City, Country) SELECT register_no SupplierName, City, Country FROM Suppliers where register_no=10;
但在一个时间是有可能选择register_no = 1,register_no = 3, register_no = 10; in one查询
答
是的,这可以通过使用
INSERT INTO Customers (register_no,CustomerName, City, Country)
SELECT register_no SupplierName, City, Country FROM Suppliers where register_no in (1,3,10)
答
您可以使用IN
子句。
INSERT INTO Customers (register_no,CustomerName, City, Country)
SELECT register_no SupplierName, City, Country FROM Suppliers where register_no IN (1,3,10);
太谢谢你了@ B.Desai它的工作原理!!!!!! –