兔八哥极品软件园    运行: 2032天 | 文章:531 篇 | 评论:2 条 | 碎语:1条

mysql update 子查询

作者:admin 发布于:2017-1-11 15:31 Wednesday

update 
t_bill a,
    t_member b
SET 
member_id = b.id
WHERE 
a.member_card_number = b.card_number 
and a.car_number IS NOT null


Powered by 兔八哥极品软件 苏ICP备12049267号 sitemap