使用
INSERT ... SELECt语句从中选择常量值和数据
products_temp:
INSERT INTO products (product_data, vendor_id) SELECT data, '1' FROM products_temp

使用
INSERT ... SELECt语句从中选择常量值和数据
products_temp:
INSERT INTO products (product_data, vendor_id) SELECT data, '1' FROM products_temp