$sql="delete member_detail.* left join member on member_detail.usename=member.usename where member.post<1";
楼上2位的语句我试了都没有成功。$query=<<<select delete member_detail.* left join member on member_detail.usename=member.usename where member.post<1 select; $result=mysql_query($query); echo $query; if ($result) echo "Success!";//都没有显示成功
两步 1、取出发贴量小于1的用户名 select username from member where post<1 将结果连接成串,形如'user1','user2',user3' 2、删除记录 delete from member_detail where username in (用户串)
delete from member_detail where member_detail.username in (select username from member where member.post<1);
To xuzuning:我试试看。不过没有接触过不是很清楚写法,最好能帮我写一下如何做。谢谢。To zalvsa:我这里的确没有成功代码贴出来了,会不会是MYSQL版本问题,你用的是多少版本?To ustb:问题多,发帖子多,发帖子多,付的分就多,付的分多,没有分了就破产了。
delete member_detail.* left join member on member_detail.usename=member.usename where member.post<1
select;
$result=mysql_query($query);
echo $query;
if ($result)
echo "Success!";//都没有显示成功
1、取出发贴量小于1的用户名
select username from member where post<1
将结果连接成串,形如'user1','user2',user3'
2、删除记录
delete from member_detail where username in (用户串)
member where member.post<1);