1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| DELIMITER $$
DROP FUNCTION IF EXISTS myFunc $$
CREATE FUNCTION myFunc(str varchar(255),number bigint unsigned)
RETURNS bigint(20)
BEGIN
DECLARE x bigint(20) DEFAULT 0;
SET x = (
CASE
WHEN str='test' and number = 1 THEN 233
WHEN str='hello' and number = 2 THEN 123
ELSE number
END
);
RETURN x;
END $$
DELIMITER ;
SELECT myFunc('test',1);
|