05, 2003 4:57 PM
Subject: 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
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)