score int 可空 无主键，限制0到六 用between怎么写MySQL

score int 可空 无主键，限制0到六 用between怎么写MySQL

这是要建表，还是写查询语句呢？

select * from 表名 where score between 0 and 6
建表字段约束
score int check(score between 0 and 6);

score int,check(score>=0 and score<=6);