[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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
