update test set i_status=5 where s_id in ( select max(s_id) as id from test where s_title is not null group by s_title,length(s_content) having count(*)>1 ) 执行报错,提示 : Error Code: 1093. You can't specify target table 'car' for update in FROM clause。本篇博文主要是针...
注意,这样一定要给最里面的子查询定义一个别名,不然会报另外一个错误: 自己的例子:下面这种方式报错 error code:1093 DELETE FROM Persons WHERE id NOT IN (SELECT MAX(id) FROM Persons GROUP BY NAME,age) 所以改成: DELETE FROM Persons WHERE id NOT IN (SELECT * FROM (SELECT MAX(id) FROM Persons...
【详细错误】: Error Code: 1093. You can't specify target table '_Resume' for update in FROM clause. 【错误原因】:在更新或删除目标表中数据的时候如果使用子查询,目标表不能在子查询的From语句中出现~ 原程序改造为: 1createtabletmpas 2selectA.Idfrom_Resume A 3innerjoin_UserBonA.UserId=B.UserI...
https://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html#error_er_update_table_used
Error Code: 1093. You can't specify target table 'ws_product' for update in FROM clause 这个是我们在使用update或者delete语句时,在where条件里面加入的子查询导致的。例如如下的update语句: update table set type = 'static' where id in (
managedBy_id=(SELECT id FROM users as managedBy_id WHERE login=123456) WHERE login=72584; 输出是: Error Code: 1093不能指定目标表“用户”在0.000秒内进行更新 浏览5提问于2015-10-05得票数 0 回答已采纳 2回答 尝试删除行时MySQL错误代码1093 from players and playerno <> 57; 但我收到以下错误...
mysql相关问题 1. update、delete 操作 【错误内容】:Error Code: 1093. Table '表名' is specified twice, both as a target for 'UPDATE' and as a separate source for data 【错产生经过】:update t_test1 set col1= col1_value where val1 in(select val1 from t_test2 group by val1);...
处理MySQL删除数据时Error Code: 1093. You can't specify target table '表名' for update in FROM clause 2011-12-29 14:41 −在执行:delete from _Resume where Id in(select A.Id from _Resume Ainner join _User B on&n... 伴老
Description:delete from services where service_id in (select s1.service_id from services s1 left join services s2 on s1.uplink_service_id = s2.service_id where s1.uplink_service_id <> 0 and s2.service_id is null ) Error Code : 1093 You can't specify target table 'services' for ...
error code 于是更改语句：INSERT INTO readbook (readid,readpage,readcount,bookid,userid,readtime) VALUES ( (SELECT*from (SELECT readid From readbook where userid=1and bookid=1and readpage=5) as a ),5,1,1,1,now()) ON duplicate key UPDATE 提⽰插⼊成功。之所以能成功是因为，1093错误...