do you have delete permissions on the password table?
Stephen Robert Norris wrote:
>
> 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
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
