mysql如何把查询到的结果插入到另一个表中:mysql查询插入新表 首先我们在goods表中查询SELECT goods_id FROM ecs_goods WHERE goods_name = '23423423' LIMIT 1查询goods_name对应的goods_id的值然后把查询到的goods_id的值作为参数，INSERT INTO ecs_comment (c