Hi U lucky man ,,, I can't make my locks work at all :(
BUT just a little hint , u sure it not ur _ (underscore) in table name which is a kind of wildcard that give u trouble ?? regards Kim Pedersen > Fella's, > > First of all I'd like to welcome myself to this list. Have been here before, > but now that I need your help again I decided to return. For the following question I've of course read the Manual, googled some .. Even checked the archives. Found no answer that satisfied me. > > For a website I'm writing some kinda stock-market game, really fun. You should check it out when it's done. Of course, while updating stuff on certain tables I want to do some things to prevent lost updates, dirty reads > and stuff like that. Would pretty much spoil the game for my dear users. Therefor I request a lock > > > LOCK TABLES eurostoq_units WRITE; > > That's the only table I really need a lock on. I am inserting in one other, > and updating to again one other but since I know beforehand for sure nobody > else is changing or reading from there I thought I didn't need to lock it. But now, when I do something like: > > > INSERT INTO eurostoq_transactions (walletid, unitid, value, what) > VALUES (9, 22, 400.3, 's'); > > Mysql starts Yelling at me, stating: > > > ERROR 1100: Table 'eurostoq_transactions' was not locked with LOCK > TABLES > > Now, please .. Of course I can request locks on other tables too. In fact I > did, as a workaround. But can anybody explain me why I cannot do anything (just found out I can't even do 'describe <TABLENAME>' anymore when there's > one table locked) else with any other table? > > Thanks, > Wouter > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > mvh 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]
