CREATE TABLE `jwiki_subject` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` char(25) NOT NULL DEFAULT '',
`type` mediumint(8) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL '0',
`lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`posttime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `title` (`title`),
KEY `type` (`type`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARACTER SET gbk DEFAULT COLLATE gbk_chinese_ci;
错误提示如下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 ''0',
`lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`posttime` int(10' at line 5
解决方案 »
- Mysql数据库
- mysql如何生成不重复的随机数
- 关于group by语句mysql
- mysql+tomcat,mysql的查询结果,中文全显示为乱码,jsp中的中文能正常显示,但从mysql经tomcat查询而来的结果显示为乱码.
- 这么简单的mysql 脚本为什么不好使呢,郁闷了----
- mysql的root密码如果忘了,竟然可以重置,这是不是太不安全了?
- jsp连接数据库
- 求一条SQL语句
- 我怎么连不上本地的MYSQL?????
- 在线等待!WINDOWS下C语言连接MySql数据库的问题。
- mysql 总是提示 shutdown failed; error: 'Access denied 错误
- insert into select如何接收参数
-> `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
-> `title` char(25) NOT NULL DEFAULT '',
-> `type` mediumint(8) unsigned NOT NULL DEFAULT '0',
-> `uid` mediumint(8) unsigned NOT NULL '0',
-> `lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
-> `posttime` int(10) unsigned NOT NULL DEFAULT '0',
-> PRIMARY KEY (`id`),
-> KEY `title` (`title`),
-> KEY `type` (`type`),
-> KEY `uid` (`uid`)
-> ) ENGINE=MyISAM DEFAULT CHARACTER SET gbk DEFAULT COLLATE gbk_chinese_ci;ERROR 1064 (42000): 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 ''0',
`lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`posttime` int(10) ' at line 5
mysql>