Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Partitioning

3026616Mar 8 2016 — edited Mar 15 2016

Hi All,

I'm trying to create table partition for a particular table A, based on column B, which have date in the format YYYYMMDD.

Can anyone suggest me how to create range interval partition.

This post has been answered by Dave Stokes-MySQL Community Team-Oracle on Mar 8 2016
Jump to Answer

Comments

Dave Stokes-MySQL Community Team-Oracle
Answer

It is very easy to partition by range.  See https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html for details.

Marked as Answer by 3026616 · Sep 27 2020
3026616

Thanks Dave.. It worked

1 - 2

Post Details

Added on Mar 8 2016
2 comments
457 views