mysql 把一个表某个字段的内容复制到另一张表的某个字段

最新推荐文章于 2020-08-16 21:54:06 发布

weixin_33787529

最新推荐文章于 2020-08-16 21:54:06 发布

阅读量160

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/jack088/blog/830240

版权

2019独角兽企业重金招聘Python工程师标准>>>

// 加上 WHWRE 后修改指定的，不加则全部

update `aws_users` AS b set b.`user_name` = (select a.`nickname`  from `aws_users_yangfan` AS a where a.`uid` = b.`uid` )
update `aws_users` AS b set b.`user_name` = (select a.`nickname`  from `aws_users_yangfan` AS a where a.`uid` = b.`uid` ) WHWRE  a.`uid` = 8

UPDATE `aws_users` AS b SET b.group_id = 4 WHERE b.group_id = 100

 UPDATE `aws_users` AS b SET b.group_id = 100 WHERE b.yangfan_id IN (SELECT a.`uid` FROM `aws_users_yangfan_space` AS a)

ps: http://www.jb51.net/article/48919.htm

转载于:https://my.oschina.net/jack088/blog/830240