On Wed, Mar 28, 2001 at 01:09:29PM +1000, Grahame Kelly wrote:
> Hi all.
>
> I have a table called password which has:
>
> Field Type
> uname varchar(64) Key
> passwd varchar(16)
>
> and another table user (partly shown) which has:
>
> Field Type
> uname varchar(64) Key
> status varchar(64)
> total varchar(64)
>
> and I am wishing to delete all users from passwd
> where user.status = "old".
>
> I have tried the following which according to MySQL
> manual should work (Deleting Rows from Related Tables).
>
> delete FROM password WHERE password.uname IN
> (select uname FROM user WHERE status = "old");
>
> Can anyone offer some assistance.
>
> Thanks, Grahame
What happens? Does the subselect (if run by itself) produce the results
you expect?
--
Stephen Norris [EMAIL PROTECTED]
Farrow Norris Pty Ltd +61 417 243 239
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
