作者ps9956 (HhoHho)
看板PHP
標題[請益] 資料庫匯入資料表
時間Tue Jan 15 15:53:14 2008
匯入資料表時發生下列問題,請高手幫忙解答問題原因和解決方法!
============================================================
重新匯入出現下列問題 為什麼呢><"
========================================================
錯誤
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