DROP FUNCTION IF EXISTS hzcode;
CREATE FUNCTION hzcode (s VARCHAR(255)) RETURNS VARCHAR(255)
BEGIN
DECLARE hz_code int;
DECLARE hz_py VARCHAR(255);
SET hz_code = ord(substring(s,1,1))*256+ord(substring(s,2,1))-65536;
select py into hz_py from pyk where hz_code>=pyk.HZ1 and hz_code<=pyk.HZ2;
RETURN hz_py;
END
求大神帮忙改正错误之处,3Q!!