MySQL 數據庫導入

1. 0000-00-00 00:00:00

[ERR] 1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'fee_date' at row 1

2. 查詢sql語句模式

mysql> SELECT @@sql_mode;

1. ONLY_FULL_GROUP_BY,

2. STRICT_TRANS_TABLES,

3. NO_ZERO_IN_DATE,

4. NO_ZERO_DATE,

5. ERROR_FOR_DIVISION_BY_ZERO,

6. NO_ENGINE_SUBSTITUTION

SET SESSION sql_mode = 'ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION';