Bonjour,
I have re-run my query without the other program trying to UPDATE
the table :
mysql> delete from intraday_PAR where date<'2001-04-03 00:00:00';
Query OK, 364842 rows affected (32.95 sec)
It works.
Why did both threads lock each other.
There is one doing a lot of UPDATE and my from the console doing my
DELETE. The DELETE should lock the table (so lock UPDATE) delete the
rows and then unlock the table isn't it ?
Regards,
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php