解决方案 »
- update对于同一个表,为什么有的行能够识别有的行不能识别?
- jsp连mysql问题!!!!!!!!!
- 如何在把MySql的表信息和字段信息显示到asp.net的页面中?
- 请问在MYSQL中如何区分大小写排序???
- 哪儿有关于java与mysql联接的资料
- 求一条sql语句,高分
- 关于mysql的连接,导入jar包,需要看版本吗?
- 帮帮!????那里可以申请到免费的php+mysql空间?
- 关于MYSQL的分组求值问题!求大神指点,给出思路就好了,现在脑袋一片混乱。。。
- 新人请教:UPDATE 怎样更新长文本?
- mysql表名为数字,无法执行select * from 1000532;为什么,怎么办?急急急!望高手解答,谢谢。
- mysql 不间断的出现 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '
B1.UID,
(SELECT IF(B.V1<>0,A.ATTR1,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR1')ATTR1,
(SELECT IF(B.V1<>0,A.ATTR2,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR2')ATTR2
FROM( SELECT DISTINCT UID FROM B)B1
UNION ALL
SELECT 'V2' REMARKS,
B1.UID,
(SELECT IF(B.V2<>0,A.ATTR1,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR1')ATTR1,
(SELECT IF(B.V2<>0,A.ATTR2,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR2')ATTR2
FROM( SELECT DISTINCT UID FROM B)B1
ORDER BY UID,REMARKS
B1.UID,
(SELECT IF(B.V1<>0,A.ATTR1,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR1')ATTR1,
(SELECT IF(B.V1<>0,A.ATTR2,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR2')ATTR2
FROM( SELECT DISTINCT UID FROM B)B1
UNION ALL
SELECT 'V2' REMARKS,
B1.UID,
(SELECT IF(B.V2<>0,A.ATTR1,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR1')ATTR1,
(SELECT IF(B.V2<>0,A.ATTR2,NULL) FROM A,B WHERE A.UID=B.UID AND B.UID=B1.UID AND B.ATTR_NAME='ATTR2')ATTR2
FROM( SELECT DISTINCT UID FROM B)B1
ORDER BY UID,REMARKS
测试后确实满足需求,多谢!