What are the list of statements that need to be committed before further action on the table in order to avoid a lock? I am not talking about full transactions with multiple statements and transaction integrity; instead I am referring to single statements.
I know insert should be committed but truncate has an autocommit. What is the full list of statements that need to be committed?
Need to be committed (starter list):
UPDATE
INSERT
DELETE
See Question&Answers more detail:os