I think you should use this statement. I did not try it.
DELETE FROM hinvoice h
USING dinvoice d
WHERE h.nof=d.nof
AND h.tgl < '2002-09-01';
Regards
Stephan
-Original Message-
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 13, 2002 9:25 AM
Hello,
I need to do an update on a table :
* Something like this : *
UPDATE my_table mt
SET mt.field1 = mt.field1 + 1
WHERE mt.id = 100
*
And there can have concurrent updates on this record. is there a risk of 2
(or more) updates done at the same time an
Maybe it is because some of your id are bigger than 127 wich is the limit
for the Tinyint and when it is converted to this type, "127" is replacing
all your id bigger than 127. Then you have multiple id with 127.
Regards,
Stephan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Hello,
I need to do an update on a table :
UPDATE my_table mt
SET mt.field1 = mt.field1 + 1
WHERE mt.id = 100
And there can have concurrent updates on this record. is there a risk of 2
(or more) updates done at the same time and my field and the result of the
query to damage the field or does a
Have you tried the command : "EXPLAIN SELECT select_options"
(http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see
what Indexes are used ...
Stephan
-Original Message-
From: David Bordas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:16 PM
To: Mikhail Enta