@文心快码mysql error code 1093 文心快码 MySQL 错误代码 1093 通常表示在更新或删除操作中,不能在子查询的 FROM 子句中引用目标表。 MySQL 错误代码 1093 是一个常见的错误,通常发生在尝试从一个表中选择数据的同时对该表进行更新或删除操作时。这种错误通常与 MySQL 的设计限制有关,旨在避免潜在的死锁和数据...
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. 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 ( select id from ws_product where first_name ='superman' ...
【详细错误】: 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...
Error Code 1093Posted by: Igor Kondrasovas Date: June 07, 2010 10:39AM Hello all, I'm trying to perform the following command in MySQL, but I'm getting error code 1093. Could you please help me correcting it so I can use in MySQL? I suppose I must use "sub queries", but ...
MySql 5.7 UPDATE 和 DELETE 导致的 error code [1093],错误信息Error:1093SQLSTATE:HY000(ER_UPDATE_TABLE_USED)Message:Youcan’tspecifytargettable‘%s’forupdateinFROM
MySQL更新错误1093是由于在使用子查询时,尝试对同一个表进行更新,导致的错误。这个错误的具体描述是:“You can't specify target table 'table_name' for update in FROM clause”。 错误原因: MySQL更新错误1093的原因是在使用子查询时,尝试对同一个表进行更新。在MySQL中,当你使用子查询时,子查询的结果集是不...
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错误...
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 : 1093Posted by: ankit jain Date: May 21, 2010 03:33AM Hi Folks, Please help me executing this update query. UPDATE A SET IS_DELETED = "N" WHERE A.id IN (SELECT DISTINCT A.id FROM B, A, C WHERE ((A.item = C.item OR B.item = C.item) AND DATEDIFF(...