mysql数据库，数据迁移a表到b表

最新推荐文章于 2024-08-07 23:01:08 发布

凌云客

最新推荐文章于 2024-08-07 23:01:08 发布

阅读量5.3k

点赞数

本文链接：https://blog.csdn.net/jiedao_liyk/article/details/59113360

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

开发新项目但是用到了旧项目的数据，字段名也发生了变化，怎么样把老数据导入新表？
mysql数据库，数据迁移a表到b表可以通过以下sql实现，通过select b表的字段，用于对应a表的字段，进行填充，这样可以实现：

INSERT INTO `bdatas`.`tj_members_bankinfo`(
    uid,bankname,city,address,cardno,bankuser,idcard,idcard1,idcard2,sale,isdefault,status,txtype,contact,beizhu
) SELECT 
    uid as uid,
    bankname as bankname,
    bankname as city,
    bankname as address,
    REPLACE(bankcard,' ','') as cardno,
    truename as bankuser,
    CASE WHEN length(idcard)=15 or length(idcard)=18 THEN idcard ELSE '' END as idcard,
    '' as idcard1,
    '' as idcard2,
    '0' as sale,
    '1' as isdefault,
    '-1' as status,
    'admin' as txtype,
    '' as contact,
    '' as beizhu
 FROM `ccdatas`.`jc_member` WHERE `bankcard` != '';