SELECT t2.id,t2.typeName,COUNT(t1.id) AS blogCount FROM t_blog t1 RIGHT JOIN t_blogType t2 ON t1.typeId=t2.id GROUP BY t2.typeName ORDER BY t2.orderNo;
我mac上运行报这个
数据库版本
sql
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_blog` /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE `t_blogtype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typeName` varchar(30) DEFAULT NULL,
`orderNo` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*Data for the table `t_blogtype` */
insert into `t_blogtype`(`id`,`typeName`,`orderNo`) values (1,'Java核心基础',1),(2,'Mysql',2),(3,'Tomcat',3),(4,'IT之路',6),(5,'随心生活',7),(7,'shiro',4),(9,'webservice',5),(10,'jsoup',4);
CREATE TABLE `t_blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) DEFAULT NULL,
`summary` varchar(400) DEFAULT NULL,
`releaseDate` datetime DEFAULT NULL,
`clickHit` int(11) DEFAULT NULL,
`replyHit` int(11) DEFAULT NULL,
`content` text,
`typeId` int(11) DEFAULT NULL,
`keyWord` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `typeId` (`typeId`),
CONSTRAINT `t_blog_ibfk_1` FOREIGN KEY (`typeId`) REFERENCES `t_blogtype` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
应该是编码问题吧,mac下是utf8,window下是gbk……注意下
照你说的typeName改为id就不出错,而且错误信息有说到DEFAULT CHARACTER SET utf8应该是字符集问题