sql相关
、Crazy
开始记录自己的学习成长,争取每天让自己变得优秀一点点
展开
-
【工具】2020.10全国省市区三级联动行政区划码Mysql数据,带电话区号,邮编,拼音,简称,经纬度,城市等级
全国省市区三级联动行政区划码Mysql数据以后用到直接拿就行了sys_area.sql下载地址原创 2020-10-17 13:54:33 · 1780 阅读 · 1 评论 -
JDBC driver (via the ‘serverTimezone‘ configuration property) to use a more specifc time zone value
JDBC链接错误记录知道错在哪里就随手改couldn't check if tables are already present using metadata: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' c原创 2020-09-29 15:56:59 · 2836 阅读 · 1 评论 -
mysql-1267-Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT)
mysql 执行报错[Err] 1267 - Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='数据库的排序规则编码不一致导致查看库的编码再查看各个表的编码show create table 表一;ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci CO原创 2020-09-25 17:11:24 · 31903 阅读 · 2 评论 -
[Err] 1055 - Expression of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
mysql错误[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_原创 2020-08-25 22:14:25 · 331 阅读 · 0 评论