SQL Syntax: for update [of...]

SQL Syntax: for update [of...]

Select * from TTable1 for update lock all rows in the table, only read and write select * from TTable1 where pkid = 1 for update lock only select * from Table1 a join Table2 B on. pkid = B. pkid for update: select * from Table1 a join Table2 B on. pkid = B. pkid where. pkid = 10 for update: select * from Table1 a join Table2 B on. pkid = B. pkid where. pkid = 10 for update of. pkid only locks rows that meet the conditions in table 1

 

For update locks all tables. for update, the corresponding table is locked according to the condition of the Post-table.