mysql: DELIMITER syntax error at line 1

Question

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??

Need space between DELIMITER and the delimiter. – Rick James Oct 12 '17 at 23:46 — Rick James, Oct 12 '17 at 23:46

score 6 · Answer 1 · edited May 23 '17 at 12:31

6

DELIMITER is a Mysql console command, You can't use it in phpmyadmin. To set the delimiter in phpmyadmin, see this other answer

edited May 23 '17 at 12:31

Community

1
1

answered Dec 01 '13 at 15:05

Filipe Silva

21,189
5
53
68

in the mysql console? or in phpmyadmin? – Filipe Silva Dec 01 '13 at 15:34

score 1 · Accepted Answer · answered Dec 01 '13 at 18:49

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).

mysql: DELIMITER syntax error at line 1

2 Answers2

Linked