Mysql 1093 delete删除时报错解决
错误:1093 - You can't specify target table '' for update in FROM clause
在省市县的表里,删除某一城市下所有的市
列名:id,countryname,countrycode
例如要删除北京下所有的区,
错误的写法
mysql> delete from country where id=(
select countrycode from country where countryname='北京'
);
1093 - You can't specify target table 'country' for update in FROM clause
正确的写法:
mysql> delete from country where countrycode=(
select id from
(select id from country where countryname='北京')
as t
);
Query OK, 2 rows affected