導入DB時錯誤後出現字樣

open2245

	[Err] 1067 - Invalid default value for 'overtime' [Err] 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; [Msg] Finished - Unsuccessfully -------------------------------------------------- 如提 有大大能解決嗎 感恩大大們

41580017

	应该是数据库编码的问题

open2245

	41580017 發表於 2024-12-20 16:10 应该是数据库编码的问题 謝謝大大回覆 我換了MySQL就ok了