destoon采集论坛

 找回密码
 立即注册
查看: 105|回复: 2

数据库导入提示 1064 这个是什么问题

[复制链接]

3

主题

2

回帖

17

积分

新手上路

Rank: 1

积分
17
发表于 2011-10-14 14:38:35 | 显示全部楼层 |阅读模式
MySQL Query:CREATE TABLE `destoon_ad` ( `aid` int(10) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `pid` int(10) unsigned NOT NULL default '0', `typeid` tinyint(1) unsigned NOT NULL default '0', `url` varchar(255) NOT NULL default '', `introduce` varchar(255) NOT NULL default '', `hits` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `editor` varchar(30) NOT NULL default '', `edittime` int(10) unsigned NOT NULL default '0', `fromtime` int(10) unsigned NOT NULL default '0', `totime` int(10) unsigned NOT NULL default '0', `stat` tinyint(1) unsigned NOT NULL default '0', `note` text NOT NULL, `code` text NOT NULL, `text_name` varchar(100) NOT NULL default '', `text_url` varchar(255) NOT NULL default '', `text_title` varchar(100) NOT NULL default '', `image_src` varchar(255) NOT NULL default '', `image_url` varchar(255) NOT NULL default '', `image_alt` varchar(100) NOT NULL default '', `flash_src` varchar(255) NOT NULL default '', `flash_url` varchar(255) NOT NULL default '', `key_moduleid` smallint(6) unsigned NOT NULL default '0', `key_catid` smallint(6) unsigned NOT NULL default '0', `key_word` varchar(100) NOT NULL default '', `key_id` varchar(255) NOT NULL default '', `status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`aid`)) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=gbk COMMENT='??'
MySQL Error: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 'DEFAULT CHARSET=gbk COMMENT='??'' at line 1 MySQL Errno:1064
Message:MySQL Query Error
回复

使用道具 举报

3

主题

2

回帖

17

积分

新手上路

Rank: 1

积分
17
 楼主| 发表于 2011-10-14 15:26:09 | 显示全部楼层

MySQL Query:CREATE TABLE `destoon_ad` ( `aid` int(10) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `pid` int(10) unsigned NOT NULL default '0', `typeid` tinyint(1) unsigned NOT NULL default '0', `url` varchar(255) NOT NULL default '', `introduce` varchar(255) NOT NULL default '', `hits` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `editor` varchar(30) NOT NULL default '', `edittime` int(10) unsigned NOT NULL default '0', `fromtime` int(10) unsigned NOT NULL default '0', `totime` int(10) unsigned NOT NULL default '0', `stat` tinyint(1) unsigned NOT NULL default '0', `note` text NOT NULL, `code` text NOT NULL, `text_name` varchar(100) NOT NULL default '', `text_url` varchar(255) NOT NULL default '', `text_title` varchar(100) NOT NULL default '', `image_src` varchar(255) NOT NULL default '', `image_url` varchar(255) NOT NULL default '', `image_alt` varchar(100) NOT NULL default '', `flash_src` varchar(255) NOT NULL default '', `flash_url` varchar(255) NOT NULL default '', `key_moduleid` smallint(6) unsigned NOT NULL default '0', `key_catid` smallint(6) unsigned NOT NULL default '0', `key_word` varchar(100) NOT NULL default '', `key_id` varchar(255) NOT NULL default '', `status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`aid`)) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=gbk COMMENT='??'
MySQL Error: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 'DEFAULT CHARSET=gbk COMMENT='??'' at line 1 MySQL Errno:1064
Message:MySQL Query Error
回复 支持 反对

使用道具 举报

29

主题

902

回帖

1935

积分

金牌会员

Rank: 6Rank: 6

积分
1935
发表于 2011-10-14 15:31:24 | 显示全部楼层

是不是编码不一致呀、、、
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|小黑屋|手机版|Archiver|destoon采集论坛

GMT+8, 2025-11-23 10:33 , Processed in 0.013891 second(s), 21 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表