stored procedure using while loop.
Hi experts hope every one is doing well.
please help me write stored procedure
I have 2 columns
the output I require should be in the format:
tabel name: abc
2 Jennifer, Michael
3 Paul, Mike
I have written a select statement using group_concat operator and it ha given me the exact output which I require.
select num , group_concat(name) from abc group by num;
But I need to write a stored procedure for this which shoud give the same result. Which means I should compare each row with another.
please suggest me how can it be achieved.
some one please help me .. as am new to mysql and to this forum as well....