I’m using MariaDB version 10.3.28-MariaDB-cll-lve
This site https://mariadb.com/kb/en/user-defined-variables/ says
User-defined variables names must be preceded by a single at character (@)
That’s what I usually do but recently I was rushing, forgot the ‘@ and wrote the following function which seems to work fine without the variables having ‘@’ at the front.
So is having a ‘@’ in front of a user defined variable a firm requirement or not?
If it is, why does my function work correctly without it?
DELIMITER $$
CREATE FUNCTION get_next_redacted_member_id() RETURNS INT(11)
BEGIN
DECLARE result INT SIGNED;
DECLARE lastid INT;
INSERT INTO redacted_member_id ( date_used) VALUES ( NOW() );
SET lastid = (SELECT LAST_INSERT_ID() );
SET result = -1 * lastid ;
RETURN result;
END$$
DELIMITER ;