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: