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
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
