List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 3 2001 7:31pm
Subject:Re: Table LOCKING
View as plain text  

Mike Blezien wrote:

> Hi All,
> 
> Was hoping some one maybe able to explain this error when attempting to LOCK
> MySQL tables for READ and WRITE:
> 
> Error Encountered:
> Unable to LOCK tables.
> 
> Error: Not unique table/alias: 'members' 
> 
> The correct database has been connected to, and the members table is a valid
> table. It's executed via Perl coding:
> $dbh->do("LOCK TABLES members READ, members WRITE, optin WRITE");
> 
> is this syntax incorrect??

No. You included members twice. Thus, it is not unique.
If you are going to write to it use write, otherwise use read.

> 
> Mike(mickalo)Blezien
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> Tel: 1(225)686-2002
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread81562@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Table LOCKINGMike Blezien3 Aug
  • Re: Table LOCKINGGerald Clark3 Aug
    • Re: Table LOCKINGMike Blezien3 Aug