当前位置：网站首页>MySQL check constraint

MySQL check constraint

2022-08-05 12:15:00 【Summer Invasion Bug Project】

MySQL constraint check

Conditions that must be met to enforce row data

Assume that the check constraint is defined in the salary column, and the salary column value is required to be between 1000_{2000 and an error will be reported if it is not between 1000}2000

Hint: Both oracle and sql server support check, but the lower version of mysql only supports it in syntax, but it will not take effect

//Use of checkSyntax: field name type check(check condition)Example: sex varchar(6) check(sex inspan>('man','woman'))//mysql5.7 only supports syntax, but it will not take effect