validation - If a column is null, the other one should be filled (and vice-versa), in MySQL -

how can validate question?

if column null, other 1 should filled (and vice-versa), in mysql.

i handle kind of problem @ application level rather database level, actually. i'm not aware of way validate either-or field set in mysql. said, go route of cronjob check data , update invalid rows, passive rather proactive solution, still try handle in application logic rather in database constraints.