Steve Mansfield <[EMAIL PROTECTED]> wrote:
> I'm using Mysql 3.23.51 on redhat.
> does anyone know if there is a way of deleting records using a join.
> I read somewhere that this is only supported as of version 4.x
>
Use programming language to retrieve data and then delete it.
One solution is a
I'm using Mysql 3.23.51 on redhat.
does anyone know if there is a way of deleting records using a join.
I read somewhere that this is only supported as of version 4.x
Regards,
Steve Mansfield
[EMAIL PROTECTED]
http://www.getreal.co.uk
Real Data Services Ltd 117-119 Marlborough Road Romford Essex
QL Database"
<[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 9:25
Subject: RE: how do I delete using a join in mySQL?
> > If I recall it right the statement should be following:
> >
> > DELETE FROM Contract_Table, Client_Table WHERE contract_client_id =
> &g
1 14:26
To: James R. Butzen; mySQL Database
Subject: RE: how do I delete using a join in mySQL?
> If I recall it right the statement should be following:
>
> DELETE FROM Contract_Table, Client_Table WHERE contract_client_id =
> client_id
> AND client_contact = 'corricello'
> If I recall it right the statement should be following:
>
> DELETE FROM Contract_Table, Client_Table WHERE contract_client_id =
> client_id
> AND client_contact = 'corricello' AND contract_percent = 0;
I made a copy of the database and tried this one, but it caused an error.
I'm thinking someth
.nebis.com
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 3:41 PM
To: mySQL Database
Subject: how do I delete using a join in mySQL?
hey, how do I DELETE all these Contract_Table records in mySQL?
SELECT contract_id, client_contact, contract_pe
hey, how do I DELETE all these Contract_Table records in mySQL?
SELECT contract_id, client_contact, contract_percent
FROM Contract_Table, Client_Table
WHERE contract_client_id = client_id
AND client_contact = 'corricello' AND contract_percent = 0;
I see this page, but didn't know if it was da
