运行sql文件时出现You have an error in your SQL syntax错误

原语句：CREATE TABLE order_info(
id int(11) NOT NULL AUTO_INCREMENT,
userId int(11) NULL DEFAULT NULL,
status varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ordertime datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

报错：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_I' at line 5

可能是由于数据库的版本不同引起的错误

删除datetime类型的长度，如下：

CREATE TABLE order_info(
id int(11) NOT NULL AUTO_INCREMENT,
userId int(11) NULL DEFAULT NULL,
status varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ordertime datetime NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE order_info(
id int(11) NOT NULL AUTO_INCREMENT,
userId int(11) NULL DEFAULT NULL,
status varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ordertime datetime NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

ordertime datetime NULL DEFAULT NULL,