MySQL遇到此处错误时(字段多,varchar(255)多的时候)
1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
解决方法:在末尾加上 ENGINE=InnoDB CHARACTER SET latin1;
这个方法可以将‘20201111’转换为数据库中的
(select STR_TO_DATE(ba3,'%Y%m%d %H:%i:%s'))