question about lock tables and unlock table

[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);


     My question is DO I NEED ONE OR TWO "UNLOCK TABLES" to
release the locking ? so

       Is  the answer ?
     mysql>UNLOCK TABLES
     mysql>UNLOCK TABLES

        or just

     mysql>UNLOCK TABLES


thank you.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]