I believe the correct command is LOCK TABLES with an 'S' at the end.
your quoted command says LOCK TABLE without the 'S'.
HTH
At 04:15 PM 1/20/2002 +, Arne Mueller wrote:
>Jeremy Zawodny wrote:
>>
>> On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
>> > Hi All,
>> >
>> > I've j
Jeremy Zawodny wrote:
>
> On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
> > Hi All,
> >
> > I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a
> > few minutes ago there is a strange problem I've never had in mysql
> > version 3:
> >
> > mysql> lock table .dev
On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
> Hi All,
>
> I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a
> few minutes ago there is a strange problem I've never had in mysql
> version 3:
>
> mysql> lock table .develop.Pseq read;
> ERROR 1064: You have
Hi All,
I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a
few minutes ago there is a strange problem I've never had in mysql
version 3:
mysql> lock table .develop.Pseq read;
ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at
line 1
Any idea what's wrong