mysql delimiter 出错,mysql：第1行出现DELIMITER语法错误

最新推荐文章于 2022-09-19 20:45:00 发布

皮小只

最新推荐文章于 2022-09-19 20:45:00 发布

阅读量690

点赞数

文章标签： mysql delimiter 出错

I try to add this function using the following SQL in phpmyadmin/MySQL

DROP FUNCTION IF EXISTS `__myv`;

DELIMITER ;;

CREATE FUNCTION `__myv`(`a` int, `b` int) RETURNS bigint(20)

BEGIN

return FLOOR(a / b);

END;;

DELIMITER ;

but I get this error:

Error

SQL query:

DELIMITER;

MySQL said: Documentation

#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' at line 1

How to fix this error??

解决方案

Even if DELIMITER is a console command, phpMyAdmin's import module has accepted it since many years. When opening a database and clicking on SQL, a query entered there is passed to the import module, so it should work (unless you have a very old phpMyAdmin version).