mysql - Check_constraint on database not working properly -

suppose: table_name = t1

check constraint on column c1 (y, n, '').

but when manually inserted value in c1 column other above valid values (like a), database won't give error , committed successfully.

how avoid this?

according mysql docs^here:

the check clause parsed ignored storage engines.

an alternative of create before insert trigger.