+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Partition table mysql (/showthread.php?tid=71898)
Partition table mysql - omid_student - 10-06-2018
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?
RE: Partition table mysql - InsiteFX - 10-06-2018
There are different types of partitions.
SEE:
MySQL - 19.2 Partitioning Types
RE: Partition table mysql - omid_student - 10-06-2018
(10-06-2018, 03:59 AM)InsiteFX Wrote: There are different types of partitions.
SEE:
MySQL - 19.2 Partitioning Types
I saw their my friend and i cannot use it
Only i cannot use non-primary key field in partition
RE: Partition table mysql - InsiteFX - 10-06-2018
I found this web site might be of interest to you.
Everything You Need to Know About MySQL Partitions
RE: Partition table mysql - omid_student - 10-06-2018
(10-06-2018, 08:58 AM)InsiteFX Wrote: I found this web site might be of interest to you.
Everything You Need to Know About MySQL Partitions
Thanks