Ü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