having trouble in ignore a value in sql

Question

I want to create a table where a column can't contain the value 0 have tried many times but its not working why?

The queries i have tried:

create tale t_name(a int(11) not null check(a<>0));

this query is ok but the column a is still taking the value 0 why?

MySQL silently ignores CHECK constraints, see https://stackoverflow.com/questions/2115497/check-constraint-in-mysql-is-not-working — Andomar, Apr 19 '18 at 14:26
Possible duplicate of [How do I add a check constraint to a table?](https://stackoverflow.com/questions/7522026/how-do-i-add-a-check-constraint-to-a-table) — Dazak, Apr 19 '18 at 15:57

score 0 · Answer 1 · answered Apr 19 '18 at 15:48

0

It seems that though MYSQL accepts CHECK clause in create table, but it silently ignores CHECK clause. Check the link MySQL trigger for workaround.

answered Apr 19 '18 at 15:48

Gaurav

thats ok but how we can ignore the 0 for a particular column value for a sql or mysql table? – Ami Panwar AP Apr 25 '18 at 04:52

1 Answers1