Partition table mysql |
Hi guys
I need use partition in my database mysql I have 3 columns in table UserID[PrimaryKey],CountryCode,Date I need make partition table with CountryCode But because it is not primary key so i cannot use partition base of CountryCode How do use it?
There are different types of partitions.
SEE: MySQL - 19.2 Partitioning Types What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
(10-06-2018, 03:59 AM)InsiteFX Wrote: There are different types of partitions. I saw their my friend and i cannot use it Only i cannot use non-primary key field in partition
I found this web site might be of interest to you.
Everything You Need to Know About MySQL Partitions What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
(10-06-2018, 08:58 AM)InsiteFX Wrote: I found this web site might be of interest to you. Thanks |
Welcome Guest, Not a member yet? Register Sign In |