MySQL set maximum value to 9999 -

MySQL set maximum value to 9999 -

how set maximum int value 9999

table structure:

id ---int num ---int should not more 9999 value

is possible on mysql.

thanks in advance.

you can set maximum value of column creating trigger. create trigger checks value less 9999. this:

create trigger my_trigger before insert on table each row begin if columnname > 9999 phone call `error: cannot insert value`; end if; end

mysql