MySQL Bug

MySQL update一个依赖自身数据的表 bug

You can't specify target table 'package_check_record' for update in FROM clause

Fix方案：使用中间表

Use Case:

update package_check_record
set app_platform = 'iOS'
where app_id in (select app_id
                 from (select app_id
                       from package_check_record
                       where app_platform like binary '%os') as pk);

再说一遍，MySQL不好用！