Re: QUESTION ABOUT FOREIGN KEY

[Henrique Garcia]

Hi Herve, how are you?

You cannot create a foreign key that references only filtered rows (e.g., WHERE ParamTyp = 'Type1').

Foreign keys must reference a PRIMARY KEY or UNIQUE KEY column, and MySQL does not support conditional or partial foreign keys.

If this rule is required, enforce it at the application level, or normalize the model (e.g. split PARAMS into separate tables per type).


Best regards,
Henrique Garcia