> I'm running "MySQL 4.0.23-standard", and trying to create a stored
function.
> Am I doing something wrong, or can I not create a stored function in
4.0.23?
> What I want is a stored function to take an int from a column and alter it
> (mask off the low 16-bits).
>
> SQL-query :
> CREATE FUNCTION
Nic,
At the end of the func, your sproc delimiter // needs to come before
restoration of the semi-colon as delimiter, thus:
DELIMITER //
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
RETURN CONCAT('Hello, ',s,'!');
//
DELIMITER ;
PB
-
Nic Stevens wrote:
Hi,
Still having di
At 11:41 -0700 7/7/05, Nic Stevens wrote:
Hi,
Still having difficulty with stored functions. I downloaded and installed
MySQL 5.0.7 and
I *still* cannot get stored functions to work.
I used the example for hello from section 19.2.1 of the online documentation
for MySQL and the example code doe
