Mysql报错 datetime(0) NULL

[SQL] 
CREATE TABLE `t_order`  (
  `order_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '运单id',
  `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '运单号',
  `send_date` datetime(0) NULL DEFAULT NULL COMMENT '发货时间',
  `arrive_date` datetime(0) NULL DEFAULT NULL COMMENT '到货时间',
  `send_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发货地址',
  `arrive_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址',
  `order_state` int(11) NULL DEFAULT 0 COMMENT '0是待核验 1是运输中 2是已到货 3是订单完成',
  `order_create_date` datetime(0) NULL DEFAULT NULL COMMENT '订单创建时间',
  `order_money` double NULL DEFAULT NULL COMMENT '运费',
  `order_customer` int(11) NULL DEFAULT NULL COMMENT '下单客户',
  `order_arrive_username` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
  `order_arrive_usertel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人电话',
  `order_driver` int(11) NULL DEFAULT NULL COMMENT '运输人员id',
  `order_tran` int(11) NULL DEFAULT NULL COMMENT '运输工具id',
  PRIMARY KEY (`order_id`) USING BTREE,
  INDEX `order_customer`(`order_customer`) USING BTREE,
  INDEX `order_driver`(`order_driver`) USING BTREE,
  INDEX `order_tran`(`order_tran`) USING BTREE,
  CONSTRAINT `t_order_ibfk_1` FOREIGN KEY (`order_customer`) REFERENCES `t_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `t_order_ibfk_2` FOREIGN KEY (`order_driver`) REFERENCES `t_driver` (`driver_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `t_order_ibfk_3` FOREIGN KEY (`order_tran`) REFERENCES `t_tran` (`tran_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
[Err] 1064 - 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 COMMENT '发货时间',
  `arrive_date` datetime(0) NULL ' at line 4

重点在这一句
arrive_date datetime(0) NULL ’ at line 4

mysql 会提示语法错误，原因是 datetime 长度不能设置为 0

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,

解决办法

datetime(0) 改为 datetime