数据库-新手疑问 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查询问题

关键词：