delete from password n where n.user_id in(select n.user_id from password n where n.uid='3584');

在mysql5.0中如何执行delete from password n where n.user_id in(select n.user_id from password n where n.uid='3584');这条语句

两个表的别名一致？
delete from password where user_id in(select user_id from password where uid='3584')
直接去掉别名。delete from `password` where user_id in(select user_id from `password` where `uid`='3584');
    [align=center]==== 思想重于技巧 ====
[/align]

reply via CSDN viewer
simple use the following statement.delete from password where uid = '3584'
Just one table is no need so complicated.