Hi Tom,
... you forgot to put the locking purpose: "write or read":
Ex:
"lock mytables write;"
Gelu
____________________________________________________________________
G.NET SOFTWARE COMPANY
----- Original Message -----
From: Tom Caruso <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 3:41 AM
Subject: Error Locking Tables
> Hello,
>
> I am using MySQL 3.23.47 under Windows 98 (mysql-opt) and I am having a
strange problem. I issued the "LOCK TABLES <table_name>;" command at the
command prompt and I got the following error:
>
> "ERROR 1064: You have an error in your SQL syntax near '' at line 1"
>
> The syntax looks correct to me as per the online documentation. Am I
doing something wrong or must a parameter be set to facilitate locking
tables?
>
> Thanks in advance for your help,
> Tom
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
