【MySQL】运行函数时报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA

在navicat中运行函数时报错，报错信息如下：

[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

参考博客：
怎么解决执行MySQL函数时缺少权限:错误代码1418
MySQL This function has none of DETERMINISTIC, NO SQL…错误1418 的原因分析及解决方法

解决办法之一

SHOW VARIABLES LIKE 'log_bin_trust_function_creators';
SET @@global.log_bin_trust_function_creators='On';

再次运行，成功

create FUNCTION mock_data1()
RETURNS INT
BEGIN
		DECLARE num int DEFAULT 1000000;
		DECLARE i int DEFAULT 1;
		
		WHILE i <= num DO
				-- 执行插入语句
				INSERT INTO app_user(`name`,`email`,`phone`,`gender`,`password`,`age`)
				VALUES(CONCAT('用户',i),'12436718@qq.com',CONCAT('18',FLOOR(RAND()*(999999999-100000000)+100000000)),
				FLOOR(RAND()*2),UUID(),FLOOR(RAND()*100));
				set i = i + 1;
		end WHILE;
		RETURN i;
END;

执行该函数

SELECT mock_data1();

该函数向表中插入1000000条数据

[SQL]SELECT mock_data1();
受影响的行: 0
时间: 52.276s

DELETE from app_user  -- 清除表但不能将id置零
TRUNCATE TABLE `app_user`  -- 清除表内容并将id置零