ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Partitions

Partitions

原创 Linux操作系统 作者:lindama 时间:2012-01-05 10:37:00 0 删除 编辑

http://dev.mysql.com/doc/refman/5.5/en/

1.Create TABLE  With Partition
CREATE TABLE  userData(
  `name` varchar(32) DEFAULT NULL,
   `OperTime` datetime DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
/*!50100 PARTITION BY RANGE (EXTRACT(YEAR_MONTH FROM OperTime))
(PARTITION p1104 VALUES LESS THAN (201105),
 PARTITION p1105 VALUES LESS THAN (201106),
  PARTITION p1106 VALUES LESS THAN MAXVALUE) */;
2.Alter Table Partition
ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));
 

3. Obtaining Information About Partitions

This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following:

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11075/viewspace-714460/,如需转载,请注明出处,否则将追究法律责任。

上一篇: vba
下一篇: mysql
请登录后发表评论 登录
全部评论

注册时间:2009-05-07

  • 博文量
    6
  • 访问量
    7071