mysql5.0 sql如下DROP TABLE IF EXISTS `duanwu`;
CREATE TABLE `duanwu` (
`id` int(11) NOT NULL auto_increment,
`graspqydw` int(11) NOT NULL,
`familydw` int(11) NOT NULL,
`koreadw` int(11) NOT NULL,
`ipaddress` varchar(255) character set gb2312 NOT NULL,
`post_at` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;INSERT INTO `duanwu` VALUES ('1', '1', '1', '1', '127.0.0.1', '2012-06-18 10:24:04');
INSERT INTO `duanwu` VALUES ('2', '2', '2', '2', '127.0.0.1', '2012-06-18 10:45:28');
INSERT INTO `duanwu` VALUES ('3', '3', '3', '3', '127.0.0.1', '2012-06-18 10:45:36');
需要统计出如下结果,graspqydw为1的数量,graspqydw为2的数量graspqydw为3的数量
graspqydw num
1 1
2 1
3 1
CREATE TABLE `duanwu` (
`id` int(11) NOT NULL auto_increment,
`graspqydw` int(11) NOT NULL,
`familydw` int(11) NOT NULL,
`koreadw` int(11) NOT NULL,
`ipaddress` varchar(255) character set gb2312 NOT NULL,
`post_at` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;INSERT INTO `duanwu` VALUES ('1', '1', '1', '1', '127.0.0.1', '2012-06-18 10:24:04');
INSERT INTO `duanwu` VALUES ('2', '2', '2', '2', '127.0.0.1', '2012-06-18 10:45:28');
INSERT INTO `duanwu` VALUES ('3', '3', '3', '3', '127.0.0.1', '2012-06-18 10:45:36');
需要统计出如下结果,graspqydw为1的数量,graspqydw为2的数量graspqydw为3的数量
graspqydw num
1 1
2 1
3 1
解决方案 »
- [征集] MySQL交叉表解决方案及散分
- 查询出某个节点下的所有树枝节点
- 查询未来几天内信息,发提示通知
- Mysql: Error 2003(HY000):Can't connect to MySQL server on 'localhost' (10061)
- source命令式mysql客户端自己的命令?
- MYSQL4 有没有能存999,999,000这样格式的方法.而且要能计算的!
- 关于数据库时间查询的问题!(在线急等,大家帮帮我这个新手吧,谢谢了!)
- 奇怪!!!jdo在mysql和mssql里面居然有这种怪现象...
- 关于mysql的order by的疑问。
- mysql: Number of processes running now: 0
- mysql 5.5.25的配置问题
- 急呀,请求帮忙解决个MYSQL5.1的存储过程问题,先谢谢了!
from duanwu
group by graspqydw
group by graspqydw;
from duanwu
group by graspqydw