SQL query:
DELIMITER ; ;
CREATE DEFINER = root@localhost FUNCTION __mydiv (
a int,
b int
) RETURNS bigint( 20 ) BEGIN
RETURN FLOOR( a / b ) ;
END ; ;
MySQL said: Documentation
#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)
SQL query:
DELIMITER ; ;
CREATE DEFINER =
root@localhostFUNCTION__mydiv(aint,bint) RETURNS bigint( 20 ) BEGIN
RETURN FLOOR( a / b ) ;
END ; ;
MySQL said: Documentation
#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)