开发者

mysql changing delimiter

开发者 https://www.devze.com 2023-01-01 06:25 出处:网络
I\'m trying to add this function using php myadmin, first off I get on error line 5, which is apparently because you need to change the delimiter from ; to something else so i tried this

I'm trying to add this function using php myadmin, first off I get on error line 5, which is apparently because you need to change the delimiter from ; to something else so i tried this

DELIMITER |

CREATE FUNCTION LEVENSHTEIN (s1 VARCHAR(255), s2 VARCHAR(255))
  RETURNS INT
    DETE开发者_JS百科RMINISTIC
      BEGIN


    etc....

      END

DELIMITER ;

But I get this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter |

Please help !?


solved it by installing new version of phpmyadmin, which has a delimiter box!

0

精彩评论

暂无评论...
验证码 换一张
取 消