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 );
為什么所有的資料都被洗掉了。。。。。。。。求大神回復啊。
uj5u.com熱心網友回復：
select uid from (
select uid as xiaojian from user
where (uid between 81 and 96)
having xiaojian<91 )
as temp
查詢下看這個的結果是不是所有的值都包含了
uj5u.com熱心網友回復：
報錯，但是查詢
select uid as xiaojian from user
where (uid between 81 and 96)
having xiaojian<91 )
有結果，不包括全部啊
uj5u.com熱心網友回復：
單獨執行這個能跑么? 明顯不能的嘛 ！！！！！！！select uid from (
select uid as xiaojian from user
where (uid between 81 and 96)
having xiaojian<91 )
as temp
uj5u.com熱心網友回復：
典型的自己給自己挖坑轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/103720.html
標籤：MySQL
上一篇：關于mysql函式的問題