msql
古攵鄉白勺雲
Java软件工程师、人生苦短我学Python、go go go。
展开
-
0033【MySQL】Mysql备份导入异常:@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty
解决导入sql文件时异常:ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty原创 2022-07-11 22:53:28 · 1187 阅读 · 0 评论 -
mysql编写函数带有分号报错:you *might* want to use the less safe log_bin_trust_function_creators variable
具体错误信息: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)解决办法:select @@global.log_bin_trust_funct原创 2020-06-05 13:41:38 · 602 阅读 · 0 评论 -
mysql使用timestamp报Invalid default value for BEGIN_DATE
– timestamp 不能为null– Invalid default value for ‘BEGIN_DATE’select @@global.sql_mode;– 源数据库STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION– 本地数据库STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER– 本地数据库设置set @@global.sql_mode = (select replac原创 2020-06-05 12:30:46 · 715 阅读 · 0 评论