[HY000][1093] You can't specify target table 't_hisen' for update in FROM clause
原因：
update t_hisen
set name = 'hisen'
where id in (select id from t_hisen where age = 18)
类似上面的sql，mysql update不允许表名既在update中又在子查询中。
Oracle是可以的
解决办法只有先查询，在拿出数据放在where子句中
[HY000][1093] You can't specify target table 't_hisen' fo...
错误操作1093 - You can't specify target table 'api' for updat...
使用mysql时，运行一段修改语句报错问题：[Err] 1093 - You can’t specify targ...
1: 执行下方的sql语句 报错UPDATE user SET cellNumber="13764031314",...
“Hello” “Hello” “Can you speak Chinese？” “No” “Can you sp...
ERROR 2002 (HY000): Can't connect to local MySQL server t...
If you can't fly, run; if you can't run, walk; if you can...
If you can’t fly, run. If you can’t run,walk. If you can’...
If you can’t measure it，you can’t improve it
MySQL显示ERROR 2003 (HY000): Can't connect to MySQL server ...
本文标题：MySQL-[HY000][1093] You can't sp
本文链接：https://www.haomeiwen.com/subject/sfpghqtx.html
网友评论