CREATE FUNCTION get_chsex(P_id INT)
BEGIN
DECLARE V_sex INT ;
DECLARE G_res VARCHAR(20) ;
SELECT sex INTO V_sex FROM dom_test_info WHERE id=P_id;
IF V_sex =1 then
G_res :='男'
ELSE G_res :='女'
END IF
RETURN G_res
END;
报错
Err] 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 'BEGIN
DECLARE V_sex INT ;
DECLARE G_res VARCHAR(20) ;
SELECT sex INTO V_s' at line 2
BEGIN
DECLARE V_sex INT ;
DECLARE G_res VARCHAR(20) ;
SELECT sex INTO V_sex FROM dom_test_info WHERE id=P_id;
IF V_sex =1 then
G_res :='男'
ELSE G_res :='女'
END IF
RETURN G_res
END;
报错
Err] 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 'BEGIN
DECLARE V_sex INT ;
DECLARE G_res VARCHAR(20) ;
SELECT sex INTO V_s' at line 2
[DEFINER = { user | CURRENT_USER }]
FUNCTION sp_name ([func_parameter[,...]])
RETURNS type
[characteristic ...] routine_body
BEGIN
DECLARE V_sex INT ;
DECLARE G_res VARCHAR(20) ;
SELECT sex INTO V_sex FROM dom_test_info WHERE id=P_id;
IF V_sex =1 then
G_res :='男'
ELSE G_res :='女'
END IF
RETURN G_res
END;//DELIMITER ;