关于delete与updata语句中嵌套的使用问题

[骑猪去赶集]

delete from user where uid in(
select uid from (
select uid as xiaojian from user
where (uid between 81 and 96)
having xiaojian<91 )
as temp );

[zjcxc]

重复的问题，这个子查询单独不能执行，问题就在这里，自己想想原因（这是你自己挖的坑）

select uid from (
    select uid as xiaojian from user 
    where (uid between 81 and 96) 
    having xiaojian<91 )
as temp 

[rucypli]

把select结果集create到临时表 然后再执行delete create table tmp select xxx delete from tb where xxx in (select * from tmp)