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。本篇博文主要是针...
当执行以下sql语句时会出现 Error Code:1093 错误: updatecarsettag=1whereidin(selectidfromcarwherebrand_id=182andtag=0); 1 出现错误的原因是因为修改的表和查询的表是同一个表,MySQL是不允许这样做的,我们可以通过中间再查询一次来解决: updatecarsettag=1whereidin(selectidfrom(selectidfromcarwherebrand...
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 1093 解决方法 ERROR 1093 (HY000): You can't specify target table 'clients' for update in FROM clause 或者: ERROR 1093 (HY000): You can't specify target table 'clients' for delete in FROM clause 一直以来我以为只有一种办法。不过今天翻开以前的书,发现还有一个方法。 表结构和示例数据: ...
Error Code 1093 Posted 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?
处理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... 伴老
Note (Code 1276): Field or reference 'test.testde1.id' of SELECT #2 was resolved in SELECT #1 Note (Code 1003): /* select#1 */ select `test`.`testde1`.`id` AS `id` from `test`.`testde1` where exists(/* select#2 */ select 1 from `test`.`testde2` where (`test`.`tes...
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 ...
An example of an error code is as follows: SELECT * FROM x; ERROR 1046 (3D000): No database selected Contents Shared MariaDB/MySQL error codes MariaDB-specific error codes There are three pieces of information returned in an error: A numeric error code, in this case 1046. Error code...
while executing this query m getting following error: Error Code : 1093 You can't specify target table 'A' for update in FROM clause I am not sure if it is query problem or MySqL bug.. Thanks in Advance AnkitNavigate: Previous Message• Next Message Options: Reply• Quote Subj...