这段语句没问题
SELECT DISTINCT s.username as username,s.uid as userid,s.credit as plnum,s.viewnum as onclick,b.blogid as id,b.subject as title,FROM_UNIXTIME(b.dateline) as newstime,s.usertype as befrom FROM uchome_space s INNER JOIN uchome_blog b ON s.uid=b.uid GROUP BY s.uid ORDER BY s.viewnum DESC LIMIT 3 而加入了where子句之后WHERE s.username='aessjz' 。aessjz是个用户名
SELECT DISTINCT s.username as username,s.uid as userid,s.credit as plnum,s.viewnum as onclick,b.blogid as id,b.subject as title,FROM_UNIXTIME(b.dateline) as newstime,s.usertype as befrom FROM uchome_space s INNER JOIN uchome_blog b ON s.uid=b.uid WHERE s.username='aessjz' GROUP BY s.uid ORDER BY s.viewnum DESC LIMIT 3 就无法运行了
是where的位置问题吗
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货