假设有两张表t1,t2,各自的表结构如下
表t2的主键id是表t1的外键,对应字段tid,现两表各自的记录如下:
现在要把t2的district_id更新到t1的district_id中,语法如下:
更新后结果如下:
![](http://img.blog.itpub.net/blog/attachment/201407/3/29660208_140436992064tg.png?x-oss-process=style/bb)
表t2的主键id是表t1的外键,对应字段tid,现两表各自的记录如下:
![](http://img.blog.itpub.net/blog/attachment/201407/3/29660208_1404370087Wj9z.png?x-oss-process=style/bb)
现在要把t2的district_id更新到t1的district_id中,语法如下:
- update t1 inner join t2 on t1.tid = t2.id set t1.district_id = t2.district_id;
![](http://img.blog.itpub.net/blog/attachment/201407/3/29660208_1404370441GhgO.png?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29660208/viewspace-1208352/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29660208/viewspace-1208352/