x-数据分析Mysql——TIMESTAMP数据类型错误

1、将测试数据的日期格式按照yyyy/MM/dd HH:mm:ss生成csv，就可以了。

2、执行导入命令

mysql> load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/order_info_utf1.csv'

    -> into table orderinfo

    -> fields terminated by ',';

Query OK, 539414 rows affected, 65535 warnings (9.19 sec)

Records: 539414  Deleted: 0  Skipped: 0  Warnings: 77610