Wednesday, February 28, 2018

[google-cloud-sql-discuss] I want to update MYSQL Variable on Google cloud server

here is my error 


[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)

and here is my code


DROP FUNCTION IF EXISTS `SPLIT_STR`;
DELIMITER ;;
CREATE FUNCTION `SPLIT_STR`(x longtext,
  delim VARCHAR(12),
  pos INT) RETURNS varchar(255) CHARSET utf8
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
       LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),
       delim, '')
;;
DELIMITER ;

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fc9f7a20-922d-460d-a214-a1b293894bbb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment