作者ps9956 (HhoHho)
看板Database
标题[SQL ] 资料库汇入资料表
时间Tue Jan 15 16:11:36 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 workin
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.60.11.253