Hello
I try in my program to make a lock.
I try to prevent another session to read and write from the whole table
I tried both
LOCK TABLES pstockx WRITE
and
LOCK TABLES pstockx READ
but no success.
I put in a breakpoint in my program to be sure the lock are held
and then I try to make a select from another session.
It dont lock me up :(
What am I doing wrong ,,is it some settings on server ??
8128 Query LOCK TABLES pstockx READ
031211 0:22:05 8133 Connect [EMAIL PROTECTED] on elprint
8133 Query SET SQL_BIG_SELECTS=1
8133 Query select amount from pstockx where
productID =
82846
8133 Query EXPLAIN select amount from pstockx
where pro
ductID = 10000
031211 0:23:06 8128 Query SHOW COLUMNS FROM pstockx
8128 Query SHOW INDEX FROM pstockx
8128 Query select amount from pstockx where
productID=8
2846
TIA
Kim G. Pedersen
macaos/elprint Development
+45 35373808
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
