[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: rework this
From:       Bob Lockie <bjlockie () lockie ! ca>
Date:       2004-05-31 19:55:14
Message-ID: 40BB8DA2.8010007 () lockie ! ca
[Download RAW message or body]

On 05/31/04 15:42 Donny Simonton spoke:
> It depends on which version of MySQL you are using.  Since you are using a
> subquery, I assume you are using a fairly new version.
> 
> Delete audit_log_records from audit_log_records, audit_log where
> audit_log_records.tracker_id = audit_log.tracker_id and
> audit_log.operation='A'
> 
> That should be it.  It's called a multi-table delete, but you are only
> deleting from one table.  You can't use left join or inner join with a
> multi-table delete or update.  You have to do a comma join.
> 
> Donny

Great, thanks.
I have MySQL-4.0.18 and that worked.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]