Mysql 常见报错
Mysql时区报错
- 报错信息:
The server time zone value ' й ʱ ' is unrecognized or represents more than one time zone.(时区报错)
- 解决方法:设置Mysql的时区:
set global time_zone = '+8:00';
Url 设置时区
jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
链接不可用
- 报错信息:
The last packet successfully received from the server was 870,513 milliseconds ago. The last packet sent successfully to the server was 870,544 milliseconds ago.
is longer than the server configured value of 'wait_timeout'.
You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts,
or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
- 解决办法:
show variables like '%timeout%';
set wait_timeout=1200;
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
-
错误描述:在创建表结构时有且只有一个可以在
default
或者update
时带上CURRENT_TIMESTAMP
-
解决办法:只让一个
TIMESTAMP
列在设置默认值或更新时带上CURRENT_TIMESTAMP