\u9047\u5230\u4e2a\u95ee\u9898\u8bf4\u9700\u8981\u91cd\u5efa\u4e00\u4e2a\u5b57\u6bb5\u3002\u7136\u540e\u5c1d\u8bd5\u5220\u9664:<\/p>\n\n\n\n
MariaDB [cmxt_log]> desc tl_user_sent_stat;
+———————-+————-+——+—–+———————+——-+
| Field | Type | Null | Key | Default | Extra |
+———————-+————-+——+—–+———————+——-+
| provider_id | varchar(60) | YES | MUL | NULL | |
| org_id | varchar(60) | YES | | NULL | |
| user_id | varchar(60) | YES | | NULL | |
| log_time | datetime | NO | | 0000-00-00 00:00:00 | |
| deliver_result | int(11) | YES | | NULL | |
| sent_count1 | int(11) | YES | | NULL | |
| sent_count2 | int(11) | YES | | NULL | |
| sent_count3 | int(11) | YES | | NULL | |
| sent_count4 | int(11) | YES | | NULL | |
| sent_count5 | int(11) | YES | | NULL | |
| sent_count6 | int(11) | YES | | NULL | |
| sent_count7 | int(11) | YES | | NULL | |
| sent_count8 | int(11) | YES | | NULL | |
| sent_count9 | int(11) | YES | | NULL | |
| msg_sent_size_sum | bigint(20) | YES | | NULL | |
| msg_sent_count | int(11) | YES | | NULL | |
| max_msg_size | int(11) | YES | | NULL | |
| spam_influence_count | int(11) | YES | | NULL | |
| spam_count | int(11) | YES | | NULL | |
+———————-+————-+——+—–+———————+——-+
19 rows in set (0.024 sec)<\/p>\n\n\n\n
\u62a5\u9519\uff1a
MariaDB [cmxt_log]> alter table tl_user_sent_stat drop column spam_count ;
ERROR 1067 (42000): Invalid default value for ‘log_time’<\/p>\n\n\n\n
\u53ef\u4ee5\u770b\u5230NO_ZERO_IN_DATE,NO_ZERO_DATE\uff0c\u9650\u5236\u4e86\u4e0d\u5141\u8bb8\u4f7f\u75280000-00 \u8fd9\u79cd\u683c\u5f0f\u3002
MariaDB [cmxt_log]> show variables like “%mode%”;
+————————–+————————————————————————————————————————+
| Variable_name | Value |
+————————–+————————————————————————————————————————+
| gtid_strict_mode | OFF |
| innodb_autoinc_lock_mode | 1 |
| innodb_strict_mode | ON |
| old_mode | |
| pseudo_slave_mode | OFF |
| slave_ddl_exec_mode | IDEMPOTENT |
| slave_exec_mode | STRICT |
| slave_parallel_mode | optimistic |
| sql_mode | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
| wsrep_gtid_mode | OFF |
+————————–+————————————————————————————————————————+
10 rows in set (0.089 sec)<\/p>\n\n\n\n
\u4f7f\u7528\u547d\u4ee4\u628aNO_ZERO_IN_DATE,NO_ZERO_DATE,\u53bb\u6389\u3002
MariaDB [cmxt_log]> set session
-> sql_mode=’ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;
Query OK, 0 rows affected (0.009 sec)<\/p>\n\n\n\n
MariaDB [cmxt_log]> show variables like “%mode%”;
+————————–+————————————————————————————————————–+
| Variable_name | Value |
+————————–+————————————————————————————————————–+
| gtid_strict_mode | OFF |
| innodb_autoinc_lock_mode | 1 |
| innodb_strict_mode | ON |
| old_mode | |
| pseudo_slave_mode | OFF |
| slave_ddl_exec_mode | IDEMPOTENT |
| slave_exec_mode | STRICT |
| slave_parallel_mode | optimistic |
| sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
| wsrep_gtid_mode | OFF |
+————————–+————————————————————————————————————–+
10 rows in set (0.001 sec)<\/p>\n\n\n\n
\u5728\u6267\u884c\u5220\u9664\uff0c\u6210\u529f\u4e86\u3002
MariaDB [cmxt_log]> alter table tl_user_sent_stat drop column spam_count ;
Query OK, 92555 rows affected (0.535 sec)
Records: 92555 Duplicates: 0 Warnings: 0<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9047\u5230\u4e2a\u95ee\u9898\u8bf4\u9700\u8981\u91cd\u5efa\u4e00\u4e2a\u5b57\u6bb5\u3002\u7136\u540e\u5c1d\u8bd5\u5220\u9664: MariaDB [cmxt_log]> desc tl_u […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=\/wp\/v2\/posts\/35"}],"collection":[{"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=35"}],"version-history":[{"count":1,"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=\/wp\/v2\/posts\/35\/revisions"}],"predecessor-version":[{"id":36,"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=\/wp\/v2\/posts\/35\/revisions\/36"}],"wp:attachment":[{"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yunloveting.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}