-- ----------------------------
-- Table structure for `TabName`
-- ----------------------------
DROP
TABLE
IF EXISTS `TabName`;
CREATE
TABLE
`TabName` (
`Id`
int
(11)
NOT
NULL AUTO_INCREMENT,
`
Name
`
varchar
(20)
DEFAULT
NULL
,
`
Date
`
date
DEFAULT
NULL
,
`Scount`
int
(11)
DEFAULT
NULL
,
PRIMARY
KEY
(`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=9
DEFAULT
CHARSET=utf8;
-- ----------------------------
-- Records of TabName
-- ----------------------------
INSERT
INTO
`TabName`
VALUES
(
‘1‘
,
‘小说‘
,
‘2013-09-01‘
,
‘10000‘
);
INSERT
INTO
`TabName`
VALUES
(
‘2‘
,
‘‘
,
‘2013-09-01‘
,
‘20000‘
);
INSERT
INTO
`TabName`
VALUES
(
‘3‘
,
‘小说‘
,
‘2013-09-02‘
,
‘30000‘
);
INSERT
INTO
`TabName`
VALUES
(
‘4‘
,
‘‘
,
‘2013-09-02‘
,
‘35000‘
);
INSERT
INTO
`TabName`
VALUES
(
‘5‘
,
‘小说‘
,
‘2013-09-03‘
,
‘31000‘
);
INSERT
INTO
`TabName`
VALUES (
‘6‘
,
‘‘
,
‘2013-09-03‘
,
‘36000‘
);
INSERT
INTO
`TabName`
VALUES
(
‘7‘
,
‘小说‘
,
‘2013-09-04‘
,
‘35000‘
);
INSERT
INTO
`TabName`
VALUES
(
‘8‘
,
‘‘
,
‘2013-09-04‘
,
‘38000‘
);
-- ------------------------
-- 查看数据
-- ------------------------
SELECT
*
from
TabName ;
|
-- ------------------------
-- 列转行统计数据
-- ------------------------
SELECT
Date
,
MAX
(
CASE
NAME
WHEN
‘小说‘
THEN
Scount
ELSE
0
END
) 小说,
MAX
(
CASE
NAME
WHEN
‘‘
THEN Scount
ELSE
0
END
)
FROM
TabName
GROUP
BY
Date
<br><br>
|
------ -------------------- --row-to-column statistics -------------- ------------ |
<br select &NBSP;&NBSP;&NBSP;&NBSP; Code class= "SQL keyword" >date name ,scount) as b_str From tabname &NBSP; group by date |
select Date , NAME , group_concat( NAME , ‘总量:‘ ,Scount) as b_str from TabName group by Date , NAME |
Mysql column Change statistics query, row to column statistics query