Use non-primary key field for partition mysql

Discussion in 'Programming' started by Omid Aghakhani, Oct 6, 2018.

  1. #1
    Hi
    In mysql we can use primary key or unique field for partition (Types Key,Hash,Range,...)
    In my table i need make partition base of countrycode field that that is not primary key
    How do i can use this field for partition
    I need for each country i have a table independent
     
    Omid Aghakhani, Oct 6, 2018 IP