> There has to be a better way than having to write a perl script to do it
> surely?
As already pointed out mysql does not (yet) support nested selects so you
can not do it directly. However quicker then writing a perl program is
1. Produce list of keys which need to be deleted.
2. cat keys | sed 's/^/delete from cc where key=/g' | sed 's/$/;/g' | mysql
Dave
PS: Modification to handle non-numeric keys is left to the user. ;-)
---
David Zverina
Alt Key Pty. Ltd.
http://www.altkey.com
PO Box 3121, Parramatta, 2124, Australia
--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to [EMAIL PROTECTED] with
unsubscribe in the text
