導入DB時錯誤後出現字樣
1067 - Invalid default value for 'overtime'CREATE TABLE `character_shop`(
`id` int(10) NOT NULL AUTO_INCREMENT,
`item_obj_id` int(11) NOT NULL DEFAULT 0,
`user_obj_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
`adena` int(10) UNSIGNED NOT NULL DEFAULT 0,
`overtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`end` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '蝯?璅∪? 0:?箏銝?1:撌脣?箏?撖嗆?? 2:撌脣?箏?撖園???3:?芸?粹??瑟?? 4:?芸?粹??瑚誑??',
`none` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `item_obj_id`(`item_obj_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 564 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'MyISAM free: 10240 kB; MyISAM free: 10240 kB' ROW_FORMAT = Dynamic;
Finished - Unsuccessfully
--------------------------------------------------
如提 有大大能解決嗎 感恩大大們
应该是数据库编码的问题 41580017 發表於 2024-12-20 16:10
应该是数据库编码的问题
謝謝大大回覆 我換了MySQL就ok了
頁:
[1]