The lock table syntax is correct. What is it you're trying to do, and why
do you think it's not working?
Quoting from the manual:
"Then you use LOCK TABLES, you must lock all tables that you are going to
use and you must use tyhe same alias that you are going to use in your
queries. If you are using a table multiple times in a query (with aliases)
you must get a lock for each alias!"
At 10:36 AM 4/13/01 -0400, Jerome Giudicelli wrote:
>[forwarded submission from a non-member address -- rjk]
>
>
>From: Jerome Giudicelli <[EMAIL PROTECTED]>
>Date: Fri, 13 Apr 2001 10:08:26 -0500
>Subject: MySQL and Perl DBI
>To: <[EMAIL PROTECTED]>
>
>Hi, I have a MySQL question:
>I can't seem to get the "lock tables" command to work other than from the
>command line.
>Here's the code I have been using through a CGI script:
>$q = $dbh->do("lock tables eval write");
>but that doesn't do anything!
>I have been searching a lot of sites to no avail.
>I am running MySQL version 3.22.21.
>Does anybody have any idea on what the correct syntax is or why this doesn't
>work?
>Thank you.
>
>Jérôme
Drew Taylor
mailto:[EMAIL PROTECTED]
http://www.drewtaylor.com/
