Robert-syl工作小记

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;...

SQL语句：UPDATE table_a a LEFT JOIN table_b b on a.id = b.id SET a.name = b.name WHERE a.id = b.id;