mysql版本过低CURRENT_TIMESTAMP不兼容问题 1067 - Invalid default value for ‘create_time‘

男娘i 2023-09-30 07:58 19阅读 0赞

DROP TABLE IF EXISTS `order_info`;
    CREATE TABLE `order_info`
    (
        `id`              int NOT NULL AUTO_INCREMENT,
        `user_id`         int                                                     DEFAULT NULL,
        `number`          varchar(255)                                            DEFAULT NULL,
        `price`           varchar(255)                                            DEFAULT NULL,
        `send_status`     tinyint                                                 DEFAULT NULL,
        `trade_no`        varchar(255)                                            DEFAULT NULL,
        `invoice_title`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
        `invoice_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
        `address`         varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
        `create_time`     datetime                                                DEFAULT CURRENT_TIMESTAMP,
        `update_time`     datetime                                                DEFAULT CURRENT_TIMESTAMP,
        `pay_status`      tinyint                                                 DEFAULT NULL,
        PRIMARY KEY (`id`)
    ) ENGINE = InnoDB
      AUTO_INCREMENT = 4
      DEFAULT CHARSET = utf8mb3;

`create_time` datetime DEFAULT CURRENT\_TIMESTAMP,  
mysql版本过低使用CURRENT\_TIMESTAMP会报错  
默认值只能使用NULL或EMPTY STRING