Home > IT Answers > Database > Looping,Array On Procedure MYSQL
Allies
5 pts.
Q:
Looping,Array On Procedure MYSQL
MySQL Stored Procedures, MySQL
For All IT
I have Data string "123". How to create procedure (MySQL) for string "123" to Be :
1. 123
2. 132
3. 231
4. 213
5. 312
6. 321
Point 1-6 is array.

Please Help Me an Thanks
Thanksss
ASKED: Mar 30 2009  6:27 PM GMT
Msi77
1010 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share 
SELECT comb
 FROM (
 
 SELECT model, concat( substring( model, a, 1 ) , substring( model, b, 1 ) , substring( model, c, 1 ) ) comb
 FROM (
 
 SELECT '123' AS model
 )X
 CROSS JOIN (
 
 SELECT 1 a
 UNION ALL SELECT 2 
 UNION ALL SELECT 3 
 )fst
 CROSS JOIN (
 
 SELECT 1 b
 UNION ALL SELECT 2 
 UNION ALL SELECT 3 
 )snd
 CROSS JOIN (
 
 SELECT 1 c
 UNION ALL SELECT 2 
 UNION ALL SELECT 3 
 )trd
 WHERE a <> b
 AND (
 c <> a
 AND c <> b
 )
 )x
 GROUP BY model, comb
Last Answered: Apr 10 2009  9:34 PM GMT by Msi77   1010 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _