mysql如何将一张表的查询结果插入到另外一张表;
- 目标表与数据表,表结构一致
-- 复制并创建表
create table table_B select * from talbe_A;
或
INSERT INTO table_B SELECT * FROM table_A;
- 表结构不一致或从目标表获取部分字段
INSERT INTO table_B b (name,age) SELECT name,age FROM table_A a where a.id = b.id;