select for update!

[474420502]

How to do that like "select for update" ?

[jackysp]

Hi @474420502 ,
I don't understand what your mean. Plz explain what you want to know about select for update statement.

[474420502]

@jackysp
begin
select uid, status from test where status = 0 limit 1;
update test set status = 1 where uid = uid(select);
commit

Multiple clients execute this transaction!

[shenli]

@474420502 Sorry, I can not get your point.

[474420502]

@shenli https://blog.csdn.net/claram/article/details/54023216

begin;
select * from goods where id = 1 for update;
update goods set stock = stock - 1 where id = 1;
commit;

[jackysp]

@474420502 , we have an issue about this, I think you can find some information in it. See here #2712 .

[tiancaiamao]

I still can't get your point. @474420502
When firing a issue, it's better to describe: what did you do, what you expect to see, and what's the result you got.
If it's a bug, we may fix it.
If it's some feature different from MySQL, we may clarify it.

[474420502]

I want the table like a queue.
@tiancaiamao

[474420502]

@jackysp
throw error and retry?

[jackysp]

For the transaction which contains select for update statement, when it meets some write conflict errors, the transaction will rollback and throw an error.

[474420502]

@jackysp 😃 😰