CONSTRAINTS

 CREATE DATABASE constraints;

USE constraints;

CREATE TABLE primarykey(id INT NOT NULL,PRIMARY KEY(id));

USE constraints;

CREATE TABLE uniq

 (id INT UNIQUE);

 INSERT INTO uniq VALUES(100);

 SELECT * FROM uniq;

 USE constraints;

 CREATE TABLE customer(id INT PRIMARY KEY);

 INSERT INTO customer VALUES(33);

 CREATE TABLE temp(cust_id INT , FOREIGN KEY(cust_id) references customer(id));

USE constraints;

CREATE TABLE city(id INT primary key , city varchar(80),age int ,

CONSTRAINT age_check CHECK (age >=18 AND city='hyd'));

use constraints;

CREATE TABLE newtab( age INT CHECK (age>=18));

 SHOW TABLES;