MYSQL 将A表数据插入到B表中

最新推荐文章于 2024-04-29 13:11:15 发布

Architect_Lee

最新推荐文章于 2024-04-29 13:11:15 发布

阅读量261

点赞数

文章标签： mysql 数学建模数据库

本文链接：https://blog.csdn.net/qq_40990306/article/details/131060084

版权

update t_a a set a.code=(select code from t_b b where b.id=a.id  AND a.b in('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21')); 

## 更新到T3 1-23
update t3 a set a.b = (SELECT b FROM t1  b WHERE b.id = a.id AND a.b  = '1');
update t3 a set a.b = (SELECT b FROM t1  b WHERE b.id = a.id AND a.b in('11','12','13','14','15','16','17','18','19','20') );
update t3 a set a.b = (SELECT b FROM t1  b WHERE b.id = a.id AND a.b in('22','23') );

## 更新t1 表
update t1 
set b = '' 
where b in('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23') ;

## 更新到T3 24-30
update t3 a set a.b = (SELECT b FROM t1  b WHERE b.id = a.id AND a.b in('24','25','26','27','28','29','30') );

## 更新t1 表
update t1 
set b = '' 
where b in('24','25','26','27','28','29','30') ;
update t3 a set a.b = (SELECT b FROM t1  b WHERE b.id = a.id AND b.b in('22','23') );

update t3 a set a.b = (SELECT b FROM t1  b WHERE b.id = a.id AND b.b in('22','23') );

## 更新1-23
update t1 (SELECT b FROM t1  b WHERE b.id = a.id AND b.b in('22','23') ) b set b.b = ''


update t1 
set b = '' 
where b in ('22','23');