下面的语句老是报错
CREATE TABLE IF NOT EXISTS `users` (
`uid` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` char(32) NOT NULL,
`email` varchar(100) NOT NULL,
`idcard` varchar(18) NOT NULL,
`usertype` tinyint(1) NOT NULL DEFAULT '0',
`userface` varchar(20) DEFAULT '0',
`regdate` int(10) DEFAULT NULL,
`lasttime` int(10) DEFAULT NULL,
`lastip` varchar(20) DEFAULT NULL,
`logintimes` int(10) DEFAULT '0',
`stones` int(10) DEFAULT '0',
`stonespw` varchar(50) NOT NULL DEFAULT '0',
`credits` int(10) DEFAULT '0',
`upid` int(15) NOT NULL DEFAULT '0',
`islocked` tinyint(1) DEFAULT '0',
`protection` char(1) DEFAULT '0',
`forumqx` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
partition by range (regdate)
(PARTITION p0 VALUES LESS THAN (20070801),
PARTITION p1 VALUES LESS THAN (20070901),
PARTITION p2 VALUES LESS THAN (20071001),
PARTITION p3 VALUES LESS THAN (20071101),
PARTITION p4 VALUES LESS THAN (20071201),
PARTITION p5 VALUES LESS THAN (20070701),
PARTITION p6 VALUES LESS THAN MAXVALUE );
CREATE TABLE IF NOT EXISTS `users` (
`uid` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` char(32) NOT NULL,
`email` varchar(100) NOT NULL,
`idcard` varchar(18) NOT NULL,
`usertype` tinyint(1) NOT NULL DEFAULT '0',
`userface` varchar(20) DEFAULT '0',
`regdate` int(10) DEFAULT NULL,
`lasttime` int(10) DEFAULT NULL,
`lastip` varchar(20) DEFAULT NULL,
`logintimes` int(10) DEFAULT '0',
`stones` int(10) DEFAULT '0',
`stonespw` varchar(50) NOT NULL DEFAULT '0',
`credits` int(10) DEFAULT '0',
`upid` int(15) NOT NULL DEFAULT '0',
`islocked` tinyint(1) DEFAULT '0',
`protection` char(1) DEFAULT '0',
`forumqx` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
partition by range (regdate)
(PARTITION p0 VALUES LESS THAN (20070801),
PARTITION p1 VALUES LESS THAN (20070901),
PARTITION p2 VALUES LESS THAN (20071001),
PARTITION p3 VALUES LESS THAN (20071101),
PARTITION p4 VALUES LESS THAN (20071201),
PARTITION p5 VALUES LESS THAN (20070701),
PARTITION p6 VALUES LESS THAN MAXVALUE );
`uid` int(10) NOT NULL,
`username` varchar(50) NOT NULL,
`password` char(32) NOT NULL,
`email` varchar(100) NOT NULL,
`idcard` varchar(18) NOT NULL,
`usertype` tinyint(1) NOT NULL DEFAULT '0',
`userface` varchar(20) DEFAULT '0',
`regdate` int(10) DEFAULT NULL,
`lasttime` int(10) DEFAULT NULL,
`lastip` varchar(20) DEFAULT NULL,
`logintimes` int(10) DEFAULT '0',
`stones` int(10) DEFAULT '0',
`stonespw` varchar(50) NOT NULL DEFAULT '0',
`credits` int(10) DEFAULT '0',
`upid` int(15) NOT NULL DEFAULT '0',
`islocked` tinyint(1) DEFAULT '0',
`protection` char(1) DEFAULT '0',
`forumqx` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8
partition by range (regdate)
(PARTITION p5 VALUES LESS THAN (20070701),
PARTITION p0 VALUES LESS THAN (20070801),
PARTITION p1 VALUES LESS THAN (20070901),
PARTITION p2 VALUES LESS THAN (20071001),
PARTITION p3 VALUES LESS THAN (20071101),
PARTITION p4 VALUES LESS THAN (20071201),
PARTITION p6 VALUES LESS THAN MAXVALUE );
mysql> CREATE TABLE IF NOT EXISTS `users` (
-> `uid` int(10) NOT NULL,
-> `username` varchar(50) NOT NULL,
-> `password` char(32) NOT NULL,
-> `email` varchar(100) NOT NULL,
-> `idcard` varchar(18) NOT NULL,
-> `usertype` tinyint(1) NOT NULL DEFAULT '0',
-> `userface` varchar(20) DEFAULT '0',
-> `regdate` int(10) DEFAULT NULL,
-> `lasttime` int(10) DEFAULT NULL,
-> `lastip` varchar(20) DEFAULT NULL,
-> `logintimes` int(10) DEFAULT '0',
-> `stones` int(10) DEFAULT '0',
-> `stonespw` varchar(50) NOT NULL DEFAULT '0',
-> `credits` int(10) DEFAULT '0',
-> `upid` int(15) NOT NULL DEFAULT '0',
-> `islocked` tinyint(1) DEFAULT '0',
-> `protection` char(1) DEFAULT '0',
-> `forumqx` tinyint(1) NOT NULL DEFAULT '0'
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8
-> partition by range (regdate)
-> (PARTITION p5 VALUES LESS THAN (20070701),
-> PARTITION p0 VALUES LESS THAN (20070801),
-> PARTITION p1 VALUES LESS THAN (20070901),
-> PARTITION p2 VALUES LESS THAN (20071001),
-> PARTITION p3 VALUES LESS THAN (20071101),
-> PARTITION p4 VALUES LESS THAN (20071201),
-> PARTITION p6 VALUES LESS THAN MAXVALUE );
Query OK, 0 rows affected (0.01 sec)mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| fish |
| t11 |
| t233 |
| users |
+----------------+
4 rows in set (0.00 sec)mysql> show create table users\G
*************************** 1. row ***************************
Table: users
Create Table: CREATE TABLE `users` (
`uid` int(10) NOT NULL,
`username` varchar(50) NOT NULL,
`password` char(32) NOT NULL,
`email` varchar(100) NOT NULL,
`idcard` varchar(18) NOT NULL,
`usertype` tinyint(1) NOT NULL DEFAULT '0',
`userface` varchar(20) DEFAULT '0',
`regdate` int(10) DEFAULT NULL,
`lasttime` int(10) DEFAULT NULL,
`lastip` varchar(20) DEFAULT NULL,
`logintimes` int(10) DEFAULT '0',
`stones` int(10) DEFAULT '0',
`stonespw` varchar(50) NOT NULL DEFAULT '0',
`credits` int(10) DEFAULT '0',
`upid` int(15) NOT NULL DEFAULT '0',
`islocked` tinyint(1) DEFAULT '0',
`protection` char(1) DEFAULT '0',
`forumqx` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (regdate) (PARTITION p5 VALUES LESS THAN (20070701) ENGINE = MyISAM, PARTITION p0 VALUES LESS THAN (20070801) ENGINE = MyISAM, PARTITION p1 VALUES LESS THAN (20070901) ENGINE = MyISAM, PARTITION p2 VALUES LESS THAN (20071001) ENGINE = MyISAM, PARTITION p3 VALUES LESS THAN (20071101) ENGINE = MyISAM, PARTITION p4 VALUES LESS THAN (20071201) ENGINE = MyISAM, PARTITION p6 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */
1 row in set (0.00 sec)mysql> select version()\G
*************************** 1. row ***************************
version(): 5.1.21-beta
1 row in set (0.00 sec)
INNODB表用分区好点。
看是不是版本的问题呢,我的mysql版本是:5.1.12-beta
`uid` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` char(32) NOT NULL,
`email` varchar(100) NOT NULL,
`idcard` varchar(18) NOT NULL,
`usertype` tinyint(1) NOT NULL DEFAULT '0',
`userface` varchar(20) DEFAULT '0',
`regdate` int(10) DEFAULT NULL,
`lasttime` int(10) DEFAULT NULL,
`lastip` varchar(20) DEFAULT NULL,
`logintimes` int(10) DEFAULT '0',
`stones` int(10) DEFAULT '0',
`stonespw` varchar(50) NOT NULL DEFAULT '0',
`credits` int(10) DEFAULT '0',
`upid` int(15) NOT NULL DEFAULT '0',
`islocked` tinyint(1) DEFAULT '0',
`protection` char(1) DEFAULT '0',
`forumqx` tinyint(1) NOT NULL DEFAULT '0',
KEY `idx_userid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
partition by range (regdate)
(PARTITION p5 VALUES LESS THAN (20070701),
PARTITION p0 VALUES LESS THAN (20070801),
PARTITION p1 VALUES LESS THAN (20070901),
PARTITION p2 VALUES LESS THAN (20071001),
PARTITION p3 VALUES LESS THAN (20071101),
PARTITION p4 VALUES LESS THAN (20071201),
PARTITION p6 VALUES LESS THAN MAXVALUE );