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]
