Hello MySql List,
I have create connection with VB .NET MySql, and now i must use the LOCK TABLES
statment.
I want to know how i can use this sintax ..
i must open connection - begin the LOCK TABLES - begin the select statment, and then
UNLOCK TABLES ..
I think so that is not correctly ..
MYSQL - LOCK TABLES
Hello MySql List,
I have create connection with VB .NET MySql, and now i must use the
LOCK TABLES statment.
I want to know how i can use this sintax ..
i must open connection - begin the LOCK TABLES - begin the select
statment, and then UNLOCK TABLES ..
I think so
: Thursday, June 03, 2004 1:25 PM
Subject: RE: VB .NET MYSQL - LOCK TABLES
You will need to reuse your database connection, do not open a new
connection with each call or the lock will not be there.
LOCK TABLE table1 READ;
SELECT * FROM table1;
UNLOCK TABLES;
-Original Message-
From