最新回答 / 阿星灬
[client] port=3306[mysql]default-character-set=utf8(gbk) # The default character set that will be used when a new schema or table is# created and no character set is definedcharacter-set-...
2018-07-20
已采纳回答 / 章然
单看文字当然不好理解了,个人认为同样是基础知识看书会快一些,推荐 mysql必知必会 边看边敲半天刷完。。同时mysql document也是极好的reference
2018-07-20
日期类型中date类型可以存进去七月七十七号,这个不会自动检测你所使用的日期类型是否正确,但是,datatime中的数据类型是村不进去七月七十七号的,所以datetime更好用一些。
2018-07-18
在MySql中创建自定义函数报错信息如下:
ERROR 1418 (HY000): 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>set global log_bin_trust_function_creators=1;
ERROR 1418 (HY000): 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>set global log_bin_trust_function_creators=1;
2018-07-18