MySQL :: Does Mysql Date Partition can be created on date time for every day???
Does Mysql Date Partition can be created on date time for every day???
I want row table in mysql with date partition.
1. Date partition must be on each date.
Ex : If i have one year records in table Number of partition must be 366/365. If i want to keep same partition for 2 year then number partition will be 366+366.
2. i don't want to write 366/365 date partition statement while creating table.
* When i gone through mysql partition document, it suggest create partition we have to specify each date.
3. If i use MYSQL list partition whether it will help?? is there any restriction on number of partition on table?
Is this possible in MYSQL?
Note : I have gone through mysql partition concepts. Please suggest suitable partition for above scenario.
Re: Does Mysql Date Partition can be created on date time for every day???