Re: question about lock tables and unlock table

2003-09-05 Thread Matt W
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

question about lock tables and unlock table

2003-09-05 Thread Steven Wu
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)