数据库-新手疑问 mysql查询问题
Column count doesn't match value count at row 1
insert into comments values(2,2,'reply2');
insert into comments values(3,3,'reply3');
仔细检查可以发现是insert into的字段与value个数不相等所选成的.
insert into articles values(1,'article1','content1');
insert into articles values(2,'article2','content2');
insert into articles values(3,'article3','content3');
mysql_query("insert into lz_members(username,password,email,adminid,groupid,timeoffset,customshow,posts,gender) value('$uid','$pwd','$mail','$lastip','0','10',9999,2,$post,$sex)") or die(mysql_error());
我想查出每篇article的回复数
我的sql是
select a.id,count from articles a left join comments c on
c.articleid=a.id;
这样查询的结果是:
a.id count
2 1
3 1
本文由宝马娱乐在线城发布于互联网络,转载请注明出处:数据库-新手疑问 mysql查询问题
关键词: