Problem with DECLARE variable using XAMPP / MariaDB (MySQL)

Asked Dec 11 '19 at 14:55

Active Dec 11 '19 at 14:59

Viewed 185 times

I am trying to create a function for my MariaDB using XAMPP:

create definer = root@localhost 
function sunshine.get_next_gid() returns int
BEGIN
    DECLARE next_val int;
    update sunshine.gid_seq set gid = gid + 1;
    select gid into next_val from sunshine.gid_seq;

    return next_val;
END;

I keep getting an error for the DECLARE: MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4

What am I doing wrong?

edited Dec 11 '19 at 14:59

Cid

14,968
4
30
45

asked Dec 11 '19 at 14:55

Senior Developer

What have you tried to debug the problem? Are you sure there should be `**` in line four? – Nico Haase Dec 11 '19 at 14:56
1

before the `CREATE`, add this line : `DELIMITER $$`. Replace `END;` by `END$$` followed by this line : `DELIMITER ;` – Cid Dec 11 '19 at 15:00
Does this answer your question? [Delimiters in MySQL](https://stackoverflow.com/questions/10259504/delimiters-in-mysql) – Cid Dec 11 '19 at 15:00
The DELIMITER $$ and END$$ followed by DELIMITER ; worked! Thanks – Senior Developer Dec 11 '19 at 16:07

Problem with DECLARE variable using XAMPP / MariaDB (MySQL)

0 Answers0