CODEWITHSUNDEEP
mysql
GrandAlienz
GrandAlienz

Reputation: 109

mysql function return multiple value in 1 string

can Mysql return multiple cell in 1 string ??

in sqlserver I can make function like this

CREATE FUNCTION [dbo].[getTribunByOrder]
(
    @idtrorder varchar(10)
)
RETURNS varchar(1000)
AS
BEGIN
    declare @trtribun varchar(1000)
    set @trtribun = ''
    select  @trtribun = @trtribun + nametribun +'='+ convert(varchar(3),jumlah) + ','
            from trtribun b
            where idtrorder = @idtrorder
    set @trtribun = substring(@trtribun, 0, len(@trtribun))
    RETURN @trtribun
END

return of this function = "name1=1,name2=3,name3=2"
can mysql create function like this ??

Upvotes: 0

Views: 8528

Answers (1)

Sal00m
Sal00m

Reputation: 2916

Of course you can:

Using CONCAT for example you can return multiple columns in one row:

SELECT CONCAT(column1,column2,...) FROM ...

And using GROUP_CONCAT you can return multiple rows in one row

SELECT GROUP_CONCAT(column1) FROM... WHERE... GROUP BY column1

Take a look here http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat and here http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

Upvotes: 3

Related Questions