问答详情
源自:6-1 秒杀模型管理--活动模型创建

datetime字段默认值问题

DROP TABLE IF EXISTS `promo`;

CREATE TABLE `promo`  (

  `id` int NOT NULL,

  `promo_naem` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `item_id` int NOT NULL DEFAULT 0,

  `promo_item_price` double NOT NULL DEFAULT 0,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;


SET FOREIGN_KEY_CHECKS = 1;


提问者:慕盖茨7021412 2021-08-03 20:35

个回答