Mysql处理遗留数据样例

最新推荐文章于 2024-05-09 00:12:29 发布

小疯子青

最新推荐文章于 2024-05-09 00:12:29 发布

阅读量188

点赞数

分类专栏： MySql学习记录文章标签： mysql

本文链接：https://blog.csdn.net/a1773570500/article/details/125823272

版权

MySql学习记录专栏收录该内容

2 篇文章 0 订阅

订阅专栏

insert into user_pack_info(user_id,nick_name,bind_code,invite_code,phone,email,real_name,kyc_pass,create_time,update_time,create_time_stamp,update_time_stamp)
select id user_id,nick_name,bind_code,invite_code,phone,email,real_name,real_name_auth kyc_pass,created_at create_time,updated_at update_time,UNIX_TIMESTAMP(created_at)*1000  create_time_stamp,UNIX_TIMESTAMP(updated_at)*1000 update_time_stamp
from user;

update account_info a,(select * from history_saro) b
set a.num=a.num+b.num
where a.user_id=b.user_id and a.material_type=b.material_type;