Check_constraint on database not working properly

Question

Suppose: table_name = t1

Check constraint on column c1 is (Y, N, '').

But when I manually inserted any value in c1 column other than above valid values (like A), database won't give any error and committed successfully.

How do I avoid this?

See http://stackoverflow.com/questions/2115497/check-constraint-in-mysql-is-not-working MySQl doesn't actually support `CHECK` constraints - it just silently parses them. — Michael Berkowski, Mar 21 '13 at 12:48

score 0 · Answer 1 · answered Mar 21 '13 at 12:49

0

According to MySQL Docs^HERE:

The CHECK clause is parsed but ignored by all storage engines.

An alternative of this is to create a BEFORE INSERT trigger.

answered Mar 21 '13 at 12:49

John Woo

258,903
69
498
492

score 0 · Answer 2 · answered Mar 28 '13 at 16:04

Assuming "The CHECK clause is parsed but ignored by all storage engines.", I have changed my check constraint to accept only Y and N. I also need to change the code, where i declare and initiallize the variable corresponding to this column.

Thanks for all your replies.

Check_constraint on database not working properly

2 Answers2