VIP会员
购物车
私信
发表新帖
立即签到
关注
回复
支持(
反对( 首页上一页 1 下一页尾页 1 条记录 1/1页
PHP网络编程
发表在PHP图书答疑
2009-11-24
是否精华
是
否
版块置顶:
是
否
SQL 查询:
CREATE TABLE `customers` (
`CustomerID` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`CustomerName` varchar( 64 ) default NULL ,
`CustomerEmail` varchar( 64 ) default NULL ,
`CustomerAddress` varchar( 128 ) default NULL ,
`Customerphone` varchar( 64 ) default NULL ,
`paytype` tinyint( 2 ) unsigned default NULL ,
PRIMARY KEY ( `CustomerID` )
) TYPE = MYISAM AUTO_INCREMENT =1
MySQL 返回：
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 1
我用的是appserv 2.6.0版本的 .sql文件导入时老是出错。
SQL 查询:
CREATE TABLE `memberdata` (
`m_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`m_name` varchar( 20 ) NOT NULL default '',
`m_nick` varchar( 20 ) NOT NULL default '',
`m_username` varchar( 20 ) NOT NULL default '',
`m_passwd` varchar( 20 ) NOT NULL default '',
`m_sex` varchar( 10 ) NOT NULL default '',
`m_birthday` date NOT NULL default '0000-00-00',
`m_level` varchar( 20 ) NOT NULL default '',
`m_email` varchar( 100 ) NOT NULL default '',
`m_url` varchar( 100 ) default '',
`m_phone` varchar( 100 ) default '',
`m_cellphone` varchar( 100 ) default '',
`m_address` varchar( 100 ) default '',
`m_joinDate` date NOT NULL default '0000-00-00',
PRIMARY KEY ( `m_id` )
) INSERT INTO `memberdata`
VALUES ( 1, '', '', 'admin', 'admin', 'w', '0000-00-00', 'admin', '', '', '', '', '', '0000-00-00' )
MySQL 返回：
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `memberdata` VALUES(1, '', '', 'admin', 'admin', 'w', '0000-00-00', ' at line 19
明日科技的老师 我这该怎么解决呢？
CREATE TABLE `customers` (
`CustomerID` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`CustomerName` varchar( 64 ) default NULL ,
`CustomerEmail` varchar( 64 ) default NULL ,
`CustomerAddress` varchar( 128 ) default NULL ,
`Customerphone` varchar( 64 ) default NULL ,
`paytype` tinyint( 2 ) unsigned default NULL ,
PRIMARY KEY ( `CustomerID` )
) TYPE = MYISAM AUTO_INCREMENT =1
MySQL 返回：
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 1
我用的是appserv 2.6.0版本的 .sql文件导入时老是出错。
SQL 查询:
CREATE TABLE `memberdata` (
`m_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`m_name` varchar( 20 ) NOT NULL default '',
`m_nick` varchar( 20 ) NOT NULL default '',
`m_username` varchar( 20 ) NOT NULL default '',
`m_passwd` varchar( 20 ) NOT NULL default '',
`m_sex` varchar( 10 ) NOT NULL default '',
`m_birthday` date NOT NULL default '0000-00-00',
`m_level` varchar( 20 ) NOT NULL default '',
`m_email` varchar( 100 ) NOT NULL default '',
`m_url` varchar( 100 ) default '',
`m_phone` varchar( 100 ) default '',
`m_cellphone` varchar( 100 ) default '',
`m_address` varchar( 100 ) default '',
`m_joinDate` date NOT NULL default '0000-00-00',
PRIMARY KEY ( `m_id` )
) INSERT INTO `memberdata`
VALUES ( 1, '', '', 'admin', 'admin', 'w', '0000-00-00', 'admin', '', '', '', '', '', '0000-00-00' )
MySQL 返回：
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `memberdata` VALUES(1, '', '', 'admin', 'admin', 'w', '0000-00-00', ' at line 19
明日科技的老师 我这该怎么解决呢？
分享到：
