Re: Read/write table lock

[Gerald L. Clark]

Fabio Galarraga wrote:
> 
> Hi to all:
> Somebody knows how to make a read/writa table lock?
> I'm trying with java source:
> 
> stmt.execute("LOCK TABLES table-x READ, table-x WRITE");
> ----
> stmt.execute("UNLOCK TABLES");
> 
> but it fails.
> 
> Best regards,
> Fabio Galarraga
> fabio@stripped
> 
Well you are locking table-x twice in the same lock.