{"id":290,"title":"sql\u591a\u8868\u66f4\u65b0","good":0,"bad":0,"hit":2219,"created_at":"2018-06-14 22:18:12","content":"<p>\u591a\u8868\u66f4\u65b0\uff1a<\/p><p>\u5982\uff1a\u4e00\u4e2a\u8868\u7684\u5546\u54c1\u5206\u7c7b\u5b58\u7684\u662f\u6587\u5b57\uff0c\u66f4\u5176\u5173\u8054\u66f4\u65b0\u4e3a\u53e6\u4e00\u4e2a\u5206\u7c7b\u8868\u7684id<\/p><p>update table1 inner join table2 on table1.field1=table2.field2 set table1.field2=table2.id;<\/p><p><br\/><\/p>"}