最近遇到很多数据结构的需求是这样的:
先select出来 然后在update 一下 条件不变
写一条语句搞定:
UPDATE tab_game_version as a INNER JOIN tab_game_version as b ON a.id=b.id
SET a.advert_data=0 where a.advert_data is NULL
最近遇到很多数据结构的需求是这样的:
先select出来 然后在update 一下 条件不变
写一条语句搞定:
UPDATE tab_game_version as a INNER JOIN tab_game_version as b ON a.id=b.id
SET a.advert_data=0 where a.advert_data is NULL