Hi Everyone,

I was wondering if anyone would be able to tell me the syntax to achieve inheritance in MySQL, For example:

^
|
|

Would this simply be a case of declaring the PK in Animal, e.g AnimalID, and repeating this in cat and dog?

Finally, once I have achieved this, will the tables inherit the values inputted into the main animals table automatically, or will these be repeated?

Many thanks for your time in advance - J

that's the simplest way, yes

however, there is no "inheritance" of data values as you were hoping

for additional information, search supertype/subtype

That's fine, I expected that would be the case. Thanks for your help