看板 PHP 關於我們 聯絡資訊
匯入資料表時發生下列問題,請高手幫忙解答問題原因和解決方法! ============================================================ 重新匯入出現下列問題 為什麼呢><" ======================================================== 錯誤 SQL 語法: -- -------------------------------------------------------- -- -- 資料表格式: `users` -- CREATE TABLE `users` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `account` varchar( 10 ) COLLATE utf8_unicode_ci NOT NULL default '', `password` varchar( 10 ) COLLATE utf8_unicode_ci NOT NULL default '', `name` varchar( 10 ) COLLATE utf8_unicode_ci NOT NULL default '', `sex` char( 2 ) COLLATE utf8_unicode_ci NOT NULL default '', `year` tinyint( 4 ) NOT NULL default '0', `month` tinyint( 4 ) NOT NULL default '0', `day` tinyint( 4 ) NOT NULL default '0', `telephone` varchar( 20 ) COLLATE utf8_unicode_ci NOT NULL default '', `cellphone` varchar( 20 ) COLLATE utf8_unicode_ci NOT NULL default '', `address` varchar( 50 ) COLLATE utf8_unicode_ci NOT NULL default '', `email` varchar( 50 ) COLLATE utf8_unicode_ci NOT NULL default '', `url` varchar( 50 ) COLLATE utf8_unicode_ci NOT NULL default '', `comment` text COLLATE utf8_unicode_ci NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =2; MySQL 傳回: #1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 210.60.11.253
ppcat:把 "ENGINE = InnoDB" 刪掉試試看? 01/15 17:14
PsMonkey:唉...之前就已經有人給了答案,還 cp 了兩個版... 01/15 18:25
JeffMcBride:我去螃蟹區cp 01/15 21:30
yanli2:那我去老虎區 01/15 21:48
ps9956:謝謝各位問題已解決! PS.對這版位置不熟,才會CP幾個版 01/16 22:38