From: Baron Schwartz
Date: April 13 2007 11:32pm
Subject: Re: creating a function in mysql
List-Archive: http://lists.mysql.com/mysql/206156
Message-Id: <4620131C.8050304@xaprb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Andrey Dmitriev wrote:
> Thanks, that works..
>  
> Next question
>  
> Does MySql support using it's own functions within this code?
>  
> E.g. I tried
>  
> set str = select concat (str,'hello');
> set str = concat (str, 'hello');
>  
> And it didn't seem to like either.

Eliminate the spaces between the function name and the parens and it'll be 
happier.  There's a configuration setting that controls this if you really want 
to tweak it, but I always just eliminate the parens.

Baron