About the delete and updata statement on the use of nested-CodePudding

The delete from the user where the uid (in
Select the uid from (
Select the uid as xiaojian the from user
The where (uid between 81 and 96)
Having xiaojian<91)
As temp);

Why all the data are deleted,,,,,,,,,, for a great god reply ah,

CodePudding user response:

 
Select the uid from (
Select the uid as xiaojian the from user 
The where (uid between 81 and 96) 
Having xiaojian<91) 
As temp

Under the query to see if the results of all values are included

CodePudding user response:

An error, but the query

 
Select the uid as xiaojian the from user 
The where (uid between 81 and 96) 
Having xiaojian<91)

Have the result, does not include all

CodePudding user response:

Carry out this can run independently? Obviously not!!!!!!!!!!!!!!!

 select the uid from (
Select the uid as xiaojian the from user 
The where (uid between 81 and 96) 
Having xiaojian<91) 
As temp

CodePudding user response:

The typical yourself digging holes