处理MySQL删除数据时Error Code: 1093. You can't specify target table '表名' for update in FROM clause
在执行:deletefrom_ResumewhereIdin(selectA.Idfrom_ResumeAinnerjoin_UserBonA.UserId=B.UserIdwhere A.CreateTime < B.CreateTime):【详细错误】:Error Code: 1093. You can't specify target table '_Resume' for update in FROM clause.【错误原因】:在更新或删除目标表中数据的时候如果使用子查询,目标表不能在子查询的From语句中出现~原程序改造为:1createtabletm
Copyright © abandonship