Re: TODO Request

Ühel kenal päeval, T, 2006-08-29 kell 22:12, kirjutas Joshua D. Drake:
> >> Auto creations of partitions
> 
> This would be something like:
> 
> create table foo () partition by ...

from the referenced MySQL manual entry

CREATE TABLE members (   ...   joined DATE NOT NULL
)
PARTITION BY KEY(joined)
PARTITIONS 6;

Do you have any idea how this should work ?

What date range should go into which partition ?


> For reference I am directly apply my fair use rights to the above per 
> the MySQL development docs. Reference below:
> 
> http://dev.mysql.com/doc/refman/5.1/en/partitioning.html
> 
> Yes I am fully aware that we don't need to do something just because 
> MySQL does it. However, Oracle has similar functionality and I would 
> like to see us keep up :)
> 
> Of course I would like it to be done correctly :)
> 

Do you know if ther is anything about partitioning in any ISO/ANSI SQL
standards ?

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com