php - 如何将多个选定的行值从其他表插入到新表

Question

from one Query is it possible to do?

将一张表中的多选行信息插入到另一张表中喜欢:

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；在一次查询中

Answer 1

是的，可以通过在

中使用

INSERT INTO Customers (register_no,CustomerName, City, Country)
SELECT register_no SupplierName, City, Country FROM Suppliers where register_no in (1,3,10)