更新时间:2023-02-05 09:29:13
使用 INSERT ... SELECT
语句,您在其中选择常量值以及来自 products_temp
的数据:
Use an INSERT ... SELECT
statement where you are selecting constant values as well as data from products_temp
:
INSERT INTO products (product_data, vendor_id)
SELECT data, '1' FROM products_temp