mysql changing delimiter
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!
精彩评论