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