Select * from sequences with (xlock)

Mysql write correct?
Why the tip: MySQL server version for the right syntax to use near '(xlock) at line 1

Please help to look at

CodePudding user response:

Certainly not ah, MYSQL errors,

CodePudding user response:

How do you write that? Lock table exclusive lock

CodePudding user response:

exclusive Lock (Lock) X

 select * from sequences for update 

Shared Lock Lock (S)
The lock in

 select * from sequences share mode 

CodePudding user response:

Exclusive lock
Select * from sequences for update.