Re: RANGE Partitioning - Questions/Suggestions

[jey Razack]

> CREATE TABLE `tr` (
> `id` int(11) default NULL,
> `name` varchar(50) default NULL,
> `purchased` date default NULL
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
> PARTITION BY RANGE (YEAR(purchased)) (
> PARTITION p0 VALUES LESS THAN (1980) ENGINE =
> MyISAM,
> AUTOPARTITION ON p(n+1) VALUES YEAR(purchased)+1
> LIMIT 200 ENGINE = MyISAM
> )
>
> Syntax explanation for example AUTOPARTITION:
>


Just to be cautioned:

In real production environment the partitions is usually based on the day (YYYYMMDD) key.
p(n+1) could be p(YYYYMMDD+1) or could be date + 1.

Regards..Jey



Edited 1 time(s). Last edit at 11/16/2005 08:28AM by jey Razack.