導入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. The community focus and support channels mentioned show how important player assistance is in online gaming.
For those seeking uninterrupted gaming experiences, Poki offers thousands of free online games that load instantly without installation hassles. 1067 - Invalid default value for 'overtime'
mysql5.7以上禁用 datetime 默认值 0000-00-00 00:00:00
頁:
[1]