Loc Conflict

Manual Locking

Table locks can be assigned manually using the LOCK TABLE command. The command is normally used by application programmers. If an application should behave in a manner that requires additional locking being performed, this command could prove very useful. However, as a general guideline avoid high locking levels. Manual locking overrides automatic locking and permits or denies access to a table or view by other users for the duration of your operation.

Example Row Share:

Example of Row Exclusive:

Example of Share:

Example of Share row Exclusive:

Example of Exclusive:

Killing User Session: