![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
来杯java茶
这个作者很懒,什么都没留下…
展开
-
mysql提取数据在几天前,几月前,几年前
( CASE WHEN TIMESTAMPDIFF( MINUTE, '时间', NOW( ) ) > 60 THEN IF ( TIMESTAMPDIFF( HOUR, '时间',, NOW( ) ) > 24, IF ( TIMESTAMPDIFF( DAY, '时间',, NOW( ) ) > 365, ...原创 2019-11-04 18:51:39 · 555 阅读 · 0 评论 -
this is incompatible with sql_mode=only_full_group_by
出现这个报错是因为MYsql5.7的安全机制问题 在etc/my.cnf 下加入 sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 如果没有权限保存 :wq! 强行保存 servi...原创 2019-05-09 15:52:11 · 114 阅读 · 0 评论 -
表情MYSQL支持
注意:是添加内容 [client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] character-set-client-handshake=FALSE character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci ini...原创 2019-05-16 14:40:15 · 544 阅读 · 0 评论 -
Packet for query is too large (3648 > 2048)
max_allowed_packet=50M 设置 [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock lower_case_table_names=1 max_allowed_packet=100M symbolic-links=0 sql_mode=NO_ENGINE_SUBSTITUTION,STRI...原创 2019-09-27 17:38:39 · 149 阅读 · 0 评论