我想统计每个表的count(*),请问谁知道怎么写,我是这样写的,但是不对
SELECT `games`.count(*) as `game`,
`article`.count(*) as `article`,
`article_comments`.count(*) as `article_comments`,
`bulletin`.count(*) as `bulletin`,
`friends`.count(*) as `friends`,
`games_type`.count(*) as `games_type`,
`message`.count(*) as `message`,
`online`.count(*) as `online`,
`photo`.count(*) as `photo`,
`photo_comments`.count(*) as `photo_comments`,
`prizes`.count(*) as `prizes`,
`prizes_type`.count(*) as `prizes_type`,
`users`.count(*) as `users`
from `games`,`article`,`article_comments`,`bulletin`,`friends`,`games_type`,`message`,`online`,`photo`,`photo_comments`,`prizes`,`prizes_type`,`users`
SELECT `games`.count(*) as `game`,
`article`.count(*) as `article`,
`article_comments`.count(*) as `article_comments`,
`bulletin`.count(*) as `bulletin`,
`friends`.count(*) as `friends`,
`games_type`.count(*) as `games_type`,
`message`.count(*) as `message`,
`online`.count(*) as `online`,
`photo`.count(*) as `photo`,
`photo_comments`.count(*) as `photo_comments`,
`prizes`.count(*) as `prizes`,
`prizes_type`.count(*) as `prizes_type`,
`users`.count(*) as `users`
from `games`,`article`,`article_comments`,`bulletin`,`friends`,`games_type`,`message`,`online`,`photo`,`photo_comments`,`prizes`,`prizes_type`,`users`
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货