babados的博客

问题描述：通常情况下，使用下列各式创建的MySQL用户是可以远程访问的：grant all privileges on *.* to 'myuser'@'%' identified by 'mypassword' with grant option;或者：grant all privileges on db_name.* to 'user_name'@'%' identified by 'mypas

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 (...