Skip to content

Latest commit

 

History

History
executable file
·
24 lines (22 loc) · 942 Bytes

partitions.sql.md

File metadata and controls

executable file
·
24 lines (22 loc) · 942 Bytes

Пример использования партиций

CREATE TABLE news_range (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `idate` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `name` CHAR(255) NOT NULL DEFAULT '',
  `text` TEXT NOT NULL,
  PRIMARY KEY (`id`, `idate`),
) ENGINE=MYISAM
PARTITION BY RANGE( `idate` ) (
  PARTITION p_2010_1 VALUES LESS THAN(1262293200 + 15768000*1),
  PARTITION p_2010_2 VALUES LESS THAN(1262293200 + 15768000*2),
  PARTITION p_2011_1 VALUES LESS THAN(1262293200 + 15768000*3),
  PARTITION p_2011_2 VALUES LESS THAN(1262293200 + 15768000*4),
  PARTITION p_2012_1 VALUES LESS THAN(1262293200 + 15768000*5),
  PARTITION p_2012_2 VALUES LESS THAN(1262293200 + 15768000*6),
  PARTITION p_2013_1 VALUES LESS THAN(1262293200 + 15768000*7),
  PARTITION p_2013_2 VALUES LESS THAN(1262293200 + 15768000*8),
  PARTITION p_new VALUES LESS THAN(MAXVALUE)
  );

EXPLAIN PARTITIONS SELECT * FROM news_range;