Welcome Guest, Not a member yet? Register   Sign In
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




Theme © iAndrew 2016 - Forum software by © MyBB