database - Lock an entire single table but still allow to access other tables in the same session on MySQL -

database - Lock an entire single table but still allow to access other tables in the same session on MySQL -

is possible lock single table on mysql session , still able read , write on other unlocked tables on same session locked table while table still locked?

yes, lock tables this.

mysql database locking table-locking database-concurrency