MySQL Constraints :

Database constraints are user-defined structures that let you restrict the behaviors of columns.


NOT NULL :

In Mysql NOT NULL constraint allows to specify that a column can not contain any NULL value. MySQL NOT NULL can be used to CREATE and ALTER a table.


UNIQUE :

The UNIQUE constraint in Mysql does not allow to insert a duplicate value in a column. The UNIQUE constraint maintains the uniqueness of a column in a table. More than one UNIQUE column can be used in a table.


PRIMARY KEY :

A PRIMARY KEY constraint for a table enforces the table to accept unique data for a specific column and this constraint create a unique index for accessing the table faster.


FOREIGN KEY :

A FOREIGN KEY in mysql creates a link between two tables by one specific column of both table. The specified column in one table must be a PRIMARY KEY and referred by the column of another table known as FOREIGN KEY.


CHECK :

A CHECK constraint controls the values in the associated column. The CHECK constraint determines whether the value is valid or not from a logical expression.


DEFAULT :

In a Mysql table, each column must contain a value ( including a NULL). While inserting data into a table, if no value is supplied to a column, then the column gets the value set as DEFAULT.