原來的資料在7.5.33中，現在想升級資料庫，使用Navicat各種轉儲，各種同步，然后各種失敗。。搞了兩天了。。撐不住了來求助。。
大佬們幫看看，代碼如下：
CREATE TABLE `yljk_ecms_infotmp_article` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`classid` int(10) UNSIGNED NOT NULL DEFAULT 0,
`oldurl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`checked` tinyint(1) NOT NULL DEFAULT 0,
`tmptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`userid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0,
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`truetime` int(10) UNSIGNED NOT NULL DEFAULT 0,
`keyboard` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`newstime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`titlepic` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`ftitle` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`smalltext` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`writer` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`befrom` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`newstext` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`diggtop` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
INDEX `checked`(`checked`) USING BTREE,
INDEX `classid`(`classid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
uj5u.com熱心網友回復：
第一、 這個版本 7.5.33 是不存在的。第二、你那邊報什么錯，你倒是貼上來啊。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/32830.html
標籤：基礎類
上一篇：純小白在線求助！使用sqlyog撰寫代碼出現報錯，卻無告知報錯原因，求解答
下一篇：找不到MSVCR11