Re: question about lock tables and unlock table

: question about lock tables and unlock table Hi Need some help here: if I have two tables, alertLog, videoLog needed to lock during some processing as: mysql LOCK TABLE alertLog READ, videoLog READ after two tables are lock and do some INSERT, mysql INSERT INTO alertLog

question about lock tables and unlock table

Hi Need some help here: if I have two tables, alertLog, videoLog needed to lock during some processing as: mysql LOCK TABLE alertLog READ, videoLog READ after two tables are lock and do some INSERT, mysql INSERT INTO alertLog(alert); mysql INSERT INTO videoLog(video);