• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Partition table mysql

#1
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?
Reply

#2
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 )
Reply

#3
(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
Reply

#4
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 )
Reply

#5
(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
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.