一、首先用记事本打开SQL文件Ctrl+H打开替换
二、替换如下内容
(1).将utf8mb4_0900_ai_ci替换为utf8_general_ci
(2).将utf8mb4替换为utf8
(3).将datetime(0)替换为datetime
(4)将timestamp(0)替换为timestamp
(5)将CURRENT_TIMESTAMP(0)替换为CURRENT_TIMESTAMP
(1).将utf8mb4_0900_ai_ci替换为utf8_general_ci
(2).将utf8mb4替换为utf8
(3).将datetime(0)替换为datetime
(4)将timestamp(0)替换为timestamp
(5)将CURRENT_TIMESTAMP(0)替换为CURRENT_TIMESTAMP