MySQL Forums
Forum List  »  Partitioning

Need help to create auto increment partition based on date
Posted by: Tanmoy Moulik
Date: October 28, 2020 04:30AM

Dear Team,

I am new to mysql.I have been exploring possibility to create partition based on date.So did came across key partition case be used with date field ,however in such case number of partition is fixed.I have shared the sample sql.

create table test_date_partition
(name varchar(100),
dept varchar(100),
salary integer,
join_date date not null)
partition by key(join_date)
partitions 6;


However, I want partition in which partition should auto increment and need basis partition with old date can be dropped.Is there any method or solution to solve this issue?

Thanks in Advance!!!

Regards,
Tanmoy Moulik

Options: ReplyQuote


Subject
Views
Written By
Posted
Need help to create auto increment partition based on date
280
October 28, 2020 04:30AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.