存储过程问题 有一张表 qqqq数据结构为a b 1 a12 a23 a34 a45 a56 a6要查询的数据为a1,a2,a3,a9,a10,a5,a12怎么样用存储过程返回a9,a10,a12 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> set @str='a1,a2,a3,a9,a10,a5,a12';Query OK, 0 rows affected (0.00 sec)mysql> set @str=concat(',',@str,',');Query OK, 0 rows affected (0.00 sec)mysql>mysql> select @str:=replace(@str,concat(',',b,','),','),a,b -> from qqqq;+-------------------------------------------+------+------+| @str:=replace(@str,concat(',',b,','),',') | a | b |+-------------------------------------------+------+------+| ,a2,a3,a9,a10,a5,a12, | 1 | a1 || ,a3,a9,a10,a5,a12, | 2 | a2 || ,a9,a10,a5,a12, | 3 | a3 || ,a9,a10,a5,a12, | 4 | a4 || ,a9,a10,a12, | 5 | a5 || ,a9,a10,a12, | 6 | a6 |+-------------------------------------------+------+------+6 rows in set (0.00 sec)mysql>mysql>mysql> select @str;+--------------+| @str |+--------------+| ,a9,a10,a12, |+--------------+1 row in set (0.00 sec)mysql> 直接在你的PHP中用就行了。把四句合成一句提交。或者你把它改成存储过程就行了。 mysql 配置问题 非常急!非常急跪求详解 mysql 字符串转日期问题 MySQL中log日志数据库表应该是INNODB还是MYISAM合适? mysqlcc 无法启动问题 为什么无法启动mysql。急…… 急:mysql5.0.15的存储过程返回结果集的问题 请问大家在mysq中能进行时间运算吗? 用户问题 我的MySQL 启动不了啦 mysql,通过存储过程更新表数据. 关于MYSQL一个奇怪的编码问题 请教各位
Query OK, 0 rows affected (0.00 sec)mysql> set @str=concat(',',@str,',');
Query OK, 0 rows affected (0.00 sec)mysql>
mysql> select @str:=replace(@str,concat(',',b,','),','),a,b
-> from qqqq;
+-------------------------------------------+------+------+
| @str:=replace(@str,concat(',',b,','),',') | a | b |
+-------------------------------------------+------+------+
| ,a2,a3,a9,a10,a5,a12, | 1 | a1 |
| ,a3,a9,a10,a5,a12, | 2 | a2 |
| ,a9,a10,a5,a12, | 3 | a3 |
| ,a9,a10,a5,a12, | 4 | a4 |
| ,a9,a10,a12, | 5 | a5 |
| ,a9,a10,a12, | 6 | a6 |
+-------------------------------------------+------+------+
6 rows in set (0.00 sec)mysql>
mysql>
mysql> select @str;
+--------------+
| @str |
+--------------+
| ,a9,a10,a12, |
+--------------+
1 row in set (0.00 sec)mysql>
或者你把它改成存储过程就行了。