I was looking in this page but also on stackoverflow and google because I though this may be a quite common question but could not find anything related... I may not be using the right terminology here.
The question is quite straight forward.
Is it a good practice having nested unique keys (or mix of primary and unique keys) inside another unique key?
I have a table with columns A, B, C, D, E, F and G Primary or UNIQUE Key would be (A, B) and UNIQUE KEYS (A, B, C) and (A, B, D).
I would like to know whether or not this is kind of things are a good practice in general but also for mysql.
Thank you very much