MySQL and SQL Server update operation the same table problem

A SQL Server operation, such as

There is no problem with this.

Two MySQL operations such as

But in MySQL I wanted to implement this function, but it went wrong.

It turns out that MySQL does not support sub-queries

We can make this change so we can do it.

See no, I just add a layer in the query outside, but realized.

The code is as follows:

Create PROCEDURETESTP (inch_idint)begin  --Set @tt = (select id from UserA where id>_id); UpdateUserASet' Names '='Woaini' whereIdinch(SelectT.id from(SelectS.id fromUserA swhereS.id>_id) t);EndCall TESTP (2)DROP PROCEDURETESTPSelect  *  fromUserA

The difference between MySQL and SQL Server needs to be discovered slowly.