How can I condition a double variable to be less than 500 while creating the table in MYSQL-CodePudding

Home > Software engineering > How can I condition a double variable to be less than 500 while creating the table in MYSQL

How can I condition a double variable to be less than 500 while creating the table in MYSQL

Time：11-30

So my teacher asked me to condition the double variable so it can't be higher than 500. How can I do that when creating the table?

CodePudding user response：

You should learn how to use the CHECK CONSTRAINT IN SQL. W3School is always the first place you can learn it by yourself: https://www.w3schools.com/sql/sql_check.asp