ERRORatDAY1's recent timeline updates ERRORatDAY1's recent timeline updates | ERRORatDAY1V2EX member #285432, joined on 2018-01-22 17:49:11 +08:00 |
ERRORatDAY1's recent replies
Oct 19, 2019 Replied to a topic by BacGa Java [商品秒杀设计] 多类型 -无限购 -的秒杀方案设计，求讨论 |
大佬还是多
Sep 8, 2018 Replied to a topic by xiaoyanbot MySQL 为什么 mysql 的 timestamp 字段允许录入 0000-00-00 00:00:00 |
@ERRORatDAY1 set global sql_mode='............................,NO_ZERO_DATE';
断开连接，重新进入。或者以上两条变量设置的时候就是 session 级别；
create table t1(shijian timestamp);
insert into table t1 values(0);
ERROR 1292 (22007): Incorrect datetime value: '0' for column 'id' at row 1
断开连接，重新进入。或者以上两条变量设置的时候就是 session 级别；
create table t1(shijian timestamp);
insert into table t1 values(0);
ERROR 1292 (22007): Incorrect datetime value: '0' for column 'id' at row 1
Sep 8, 2018 Replied to a topic by xiaoyanbot MySQL 为什么 mysql 的 timestamp 字段允许录入 0000-00-00 00:00:00 |
set global explicit_defaults_for_timestamp=on;
Feb 5, 2018 Replied to a topic by wind2412 Java 用 C++ 实现了一个 jvm |
膜拜&马克
Select Language