Ü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

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to