RE: AW: explicitly specifying locks and select in locks table.

[王 旭]

Yes,i used sql studio.
What's the meaning about "committed"?Do you mean the Isolation Level?
I don't find the location of SQLStudio-input-area.Is it in the maxdb help?
thanks.  

From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "? ?" <[EMAIL PROTECTED]>, <maxdb@lists.mysql.com>
Subject: AW: explicitly specifying locks and select in locks table.
Date: Fri, 15 Apr 2005 10:20:11 +0200
[EMAIL PROTECTED] wrote:
>
> I created a table named "ht_detail".
>
> Then i insert three item in the table.
>
> After that, i executed a select statement:"select * from ht_detail 
where
> sbh ='79NK0001' with lock exclusive"
>
> After executed that  statement, i selected item from the system table
> "Locks",but there are no item in it?
>
> Why?
This happened perhaps because you used SQLStudio for doing this and used 
'committed' (see bottom of SQLStudio-input-area), which means: do a commit 
after each command causing locks to be released.
Elke
SAP Labs Berlin
>
> _________________________________________________________________
> 享用世界上最大的电子邮件系统― MSN Hotmail。  http://www.hotmail.com
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]

_________________________________________________________________
享用世界上最大的电子邮件系统― MSN Hotmail。  http://www.hotmail.com  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]