sql - Adding check constraints without "create assertion" in MYSQL -

sql - Adding check constraints without "create assertion" in MYSQL -

i'm trying add together check constraint tables orders , results in database, mysql won't take assertions. how edit fit mysql's accepted syntax? can done alter table?

create assertion check (not exists select * orders, results, orders.order_number = results.order_number , orders.order_date > results.date_reported);

mysql not back upwards check constraints, ignored. @ mysql doc see allowed syntaxes. can seek using trigger instead check inserted info @ insert/update time!

mysql sql constraints