set global log_bin_trust_function_creators=TRUE;
drop FUNCTION getStockfun;
CREATE DEFINER = CURRENT_USER FUNCTION `getStockfun`(`scode` VARCHAR(50))
RETURNS varchar(50)
BEGIN
RETURN ‘123213‘;
END;
SELECT getStockfun(‘‘)

mysql触发器