Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
A. gender char(1) check( gender IN (‘M’, ‘F’)),
B. gender char (1) check,
C. gender char (1) check ( gender ),
D. none of these
Answer:A
Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
A. gender char(1) check( gender IN (‘M’, ‘F’)), B. gender char (1) check, C. gender char (1) check ( gender ), D. none of these
Explanation: Check constraint constrains the allowable values for a particular column.