Hi,
Try,
mysql> delete from GbEntries where sender not in (select * from Accounts);
Thanks
ViSolve DB Team.
- Original Message -
From: "Christian Parpart" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 20, 2006 3:11 PM
Subject: howto query DELETE
--
My
The following statement should do the trick:
delete from GBEntries t1 where (select count(*) from Accounts nt1 where
nt1.ID=t1.Sender)=0
Performance of this query will be significantly improved if there is an
index on Accounts.ID.
HTH,
Panos.
On 12/20/06, Christian Parpart <[EMAIL PROTECTED]>
Hi all,
there is a live before foreign keys, but now I'm using mysql 5.0 ;)
how where I'm about to convert my db schema to make use of foreign keys (via
innodb) I am enforced to delete all invalid entries before.
however, I can do this using a huch select loop with a test within to delete
all w
Hi all,
there is a live before foreign keys, but now I'm using mysql 5.0 ;)
how where I'm about to convert my db schema to make use of foreign keys (via
innodb) I am enforced to delete all invalid entries before.
however, I can do this using a huch select loop with a test within to delete
all w
