使用 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