Michael Stassen wrote:
zzapper wrote:
> Hi,
> Final whinge: I wish the mysql website made it a little clearer
which > features are recent additions, I suggested color coding.
Philippe Poelvoorde wrote:
I reckon, it's a bit hidden in the middle :
"Starting with MySQL 4.0.4, you can also perfo
On Wed, 27 Apr 2005 09:51:41 -0400, wrote:
My subject is a bit of a misnomer in fact the Where refers to multiple tables
but the delete is just
from one table, nevertheless my query worked super-dandy in 4.1 (on my test
rig) and failed on the
live server 3.23.47 . that's why I couldn't work out
zzapper wrote:
> Hi,
> Final whinge: I wish the mysql website made it a little clearer
which > features are recent additions, I suggested color coding.
Philippe Poelvoorde wrote:
I reckon, it's a bit hidden in the middle :
"Starting with MySQL 4.0.4, you can also perform UPDATE operations
th
zzapper wrote:
On Wed, 27 Apr 2005 09:50:37 +0100, wrote:
zzapper wrote:
On Tue, 26 Apr 2005 23:22:46 +0100, wrote:
Hi,
The following query runs fine in recent versions of mysql 4.1x etc
delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
(t1.txtemail='[EMAIL PROTECTED]')
and (t1.int
From: "zzapper"
> Final whinge: I wish the mysql website made it a little clearer which
features are recent
> additions, I suggested color coding.
1) Someone from MySQL AB mentioned here recently that they are working on a
new system to keep track of differences between versions for the
documenta
Hi,
Final whinge: I wish the mysql website made it a little clearer which features
are recent
additions, I suggested color coding.
BTW regards multi table deletes there's something nasty there between 4.0 and
4.1
--
zzapper
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
On Wed, 27 Apr 2005 09:50:37 +0100, wrote:
>zzapper wrote:
>> On Tue, 26 Apr 2005 23:22:46 +0100, wrote:
>>
>>
>>>Hi,
>>>
>>>The following query runs fine in recent versions of mysql 4.1x etc
>>>
>>>delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
>>>(t1.txtemail='[EMAIL PROTECTE
zzapper wrote:
On Tue, 26 Apr 2005 23:22:46 +0100, wrote:
Hi,
The following query runs fine in recent versions of mysql 4.1x etc
delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
(t1.txtemail='[EMAIL PROTECTED]')
and (t1.intID = t2.intID);
But not in 3.23.47 I can't find any referenc
On Tue, 26 Apr 2005 23:22:46 +0100, wrote:
>Hi,
>
>The following query runs fine in recent versions of mysql 4.1x etc
>
>delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
>(t1.txtemail='[EMAIL PROTECTED]')
>and (t1.intID = t2.intID);
>
>But not in 3.23.47 I can't find any reference i
Hi,
The following query runs fine in recent versions of mysql 4.1x etc
delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
(t1.txtemail='[EMAIL PROTECTED]')
and (t1.intID = t2.intID);
But not in 3.23.47 I can't find any reference in the manuals to why this might
be.
Is there any cha
10 matches
Mail list logo