如下表结构:
-------------------------------------------------------------------------------------------
create table tx_score(
id int primary key,
score_no varchar(16),
student_id int,
course_id int,
score int,
comment varchar(16)
);
insert into tx_score (id,student_id,course_id,score)values
(1 ,1,1,9),
(2 ,2,1,7),
(3 ,3,1,4),
(4 ,1,2,2),
(5 ,2,2,9),
(6 ,3,2,8),
(7 ,1,3,1),
(8 ,2,3,8),
(9 ,3,3,8),
(10 ,1,4,8),
(11 ,2,4,2),
(12 ,3,4,6),
(13 ,1,4,3),
(14 ,2,4,5),
(15 ,3,4,2);
---------------------------------------------------------------------------------------------------
期望结果
+------+-----+-----+-----+-----+------+
| |1 |2 |3 |4 | |
+------+-----+-----+-----+-----+------+
|1 |09 |02 |01 |11 |23 |
|2 |07 |09 |08 |07 |31 |
|3 |04 |08 |08 |08 |28 |
+------+-----+-----+-----+-----+------+????????????????????????????????
-------------------------------------------------------------------------------------------
create table tx_score(
id int primary key,
score_no varchar(16),
student_id int,
course_id int,
score int,
comment varchar(16)
);
insert into tx_score (id,student_id,course_id,score)values
(1 ,1,1,9),
(2 ,2,1,7),
(3 ,3,1,4),
(4 ,1,2,2),
(5 ,2,2,9),
(6 ,3,2,8),
(7 ,1,3,1),
(8 ,2,3,8),
(9 ,3,3,8),
(10 ,1,4,8),
(11 ,2,4,2),
(12 ,3,4,6),
(13 ,1,4,3),
(14 ,2,4,5),
(15 ,3,4,2);
---------------------------------------------------------------------------------------------------
期望结果
+------+-----+-----+-----+-----+------+
| |1 |2 |3 |4 | |
+------+-----+-----+-----+-----+------+
|1 |09 |02 |01 |11 |23 |
|2 |07 |09 |08 |07 |31 |
|3 |04 |08 |08 |08 |28 |
+------+-----+-----+-----+-----+------+????????????????????????????????
解决方案 »
- 初学者关于官方Mysql的疑问!!!
- mysql workbench 管理工具,有三个下载,我应该下载哪一个呢?
- mysql简单的建表出错~~~本人比较菜鸟,望高手指点!!!
- 急急,求高手解答触发器错误
- 菜鸟问题
- MYSQL的字段完全书写格式问题,假设库为TEST 表名为ADMIN 语句可以写成select % from test.admin 如果再进一步要导出字段中的数据,假设字段有一个NAME,是写成像name.test.admin test.admin.na
- mysql大数量处理
- mySQL管理
- 十万火急,大侠大侠快来救我!
- 在win环境中,如何使用ADO连接远端mysql而不用ODBC连接
- mysql建表,时间字段设置默认值问题
- mysql-5.6.16-win32安装后show databases看不到mysql缺省数据库?
MySQL交叉表
在某些数据库中有交叉表,但在MySQL中却没有这个功能,但网上看到有不少朋友想找出一个解决方法,特发贴集思广义。http://topic.csdn.net/u/20090530/23/0b782674-4b0b-4cf5-bc1a-e8914aaee5ab.html?96198现整理解法如下:数据样本: create table tx( id int primary key, c1 c...