Cannot create function in MySQL

Question

I cannot add custom function to my MySql database, I have problems even with simple function like this

DELIMITER $$
DROP FUNCTION IF EXISTS `foo`$$
CREATE FUNCTION `foo`(IN doWork boolean) RETURNS boolean
    NO SQL
    DETERMINISTIC
BEGIN
  return doWork;

END%%
DELIMITER ;

when I execute above query , phpmyadmin show that all is ok, but when I want to call this function phpmyadmin say's that cannot find this function, also table ROUTINES in information_schema dont contains it.

juergen d · Accepted Answer · 2012-08-01 21:29:40Z

1

your end delimiter is different from the defined one

replace

END%%

with

END $$

answered Aug 1, 2012 at 21:29

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot create function in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related