mysql执行以下SQLupdate 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' ...
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 ...
MySql 5.7 UPDATE 和 DELETE 导致的 error code [1093],错误信息Error:1093SQLSTATE:HY000(ER_UPDATE_TABLE_USED)Message:Youcan’tspecifytargettable‘%s’forupdateinFROM
ERROR 1093 (HY000): You can't specify target table 'b' for update in FROM clause 从oracle转mysql的同志们,估计都会遇到上面这种情况,怎么这样的sql执行不了。 为什么会这样? 字面意思就是update的表不能出现在from语句中,原因是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... 伴老
mysql报错ERROR 1093 今天在尝试用子查询来关联更新一个表的收到如下报错: ERROR 1093 (HY000): You can't specify target table 'v_member_info' for update in FROM clause 具体执行的sql如下: MySQL[meminfo]> update v_member_info set cust_right_group=0 where id in (select id from v_member_...
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 Ankit Subject Written By Posted Error Code : 1093 ankit jain May 21, 2010 03:33AM ...
mysql Error1093错误 >createtabletest(idint,namevarchar(12),primarykey(id));Query OK,0rowsaffected(0.04sec)mysql>insertintotestvalues(1,'ttt');Query OK,1rowaffected(0.00sec)mysql>insertintotestvalues(2,'ttt');Query OK,1rowaffected(0.00sec)mysql>commit;Query OK,0rowsaffected(0.00sec)mysql>...