導入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了
Whenever I have free time, I often play Suika game for entertainment. This game not only helps me relieve stress but also trains my thinking and organizing skills. Although it seems simple, to get a high score, I have to carefully calculate the position of the fruits and predict where they will roll. Discovering cool games is my passion, and recently I discovered Slitherio — a simple yet extremely addictive game where I can control a small snake, collect glowing dots to grow, and try to survive as long as possible among hundreds of other players.
頁:
[1]