how to use check condition in column during insertion

[rahullko05]

I want to add a check condition to the column. I use the following script

DROP TABLE IF EXISTS `Customer`;
CREATE TABLE `Customer`
(
`CustomerId` INT UNSIGNED NOT NULL UNIQUE AUTO_INCREMENT
,`Name` VARCHAR(16) NOT NULL
,`Sex` CHAR(1) CHECK('M')
,PRIMARY KEY (`CustomerId`)
);

But when i try to insert wrong data, it inserts

INSERT INTO Customer(`Name`, `Sex`)
VALUES('John Smith', 'Q');

[SLauren]

Try with ENUM data type as below:

DROP TABLE IF EXISTS `Customer`;
CREATE TABLE `Customer`
(
`CustomerId` INT UNSIGNED NOT NULL UNIQUE AUTO_INCREMENT
,`Name` VARCHAR(16) NOT NULL
,`Sex` ENUM('M', 'F')
,PRIMARY KEY (`CustomerId`)
);
 

Thanks,
Lauren

[rahullko05]

thanks a lot..appreciated...its working..!!