Re: Strange issue in a stored procedure [SOLVED]

2008-08-07 Thread Nicolas Sebrecht
Nicolas Sebrecht a écrit: > mysql> CREATE DATABASE dbtest; > mysql> DELIMITER $$ > mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$ > mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130)) > -> BEGIN > -> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1)); > -> END$$

Strange issue in a stored procedure

2008-08-07 Thread Nicolas Sebrecht
Hello, I need help since I fail to set up a basic stored procedure. Here are the executed commands and the error I get: mysql> CREATE DATABASE dbtest; mysql> DELIMITER $$ mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$ mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130)) ->