/* 006 - Constraints () column me kaisa data aayega aur kaisa nahe , column blank ya duplicate data, */ -- UNIQUE, NOT NULL, CHECK(age >=18), DEFAULT CREATE TABLE tOne( id INT NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, age INT NOT NULL CHECK(age >= 18), gender VARCHAR(1) NOT NULL, phone VARCHAR(10) NOT NULL UNIQUE, city VARCHAR(15) NOT NULL DEFAULT 'Agra' ); -- CHECK_FOR_NOT_NULL like gender INSERT INTO tOne(id,name,age,gender,phone,city) VALUES (20,"SSarita","18","4015155","Agra"); -- -error column count doesnot match value count */ -- default constrint like city name INSERT INTO tOne(id,name,age,gender,phone,city) VALUES(30,"Salman Khan","20","M","4012155"); -- -error column count doesnot match value count */ -- unique Constraints like phone number INSERT INTO tOne(id,name,age,gender,phone,city) VALUES(4,"Juhi Chawla","21","F","4016155"); -- -error #1062 - Duplicate entry '4015155' for key 'phone' */ -- check Constraints like age INSERT INTO tOne(id,name,age,gender,phone,city) VALUES(5,"John","18","F","4017755"); -- -error column count doesnot match value count */