How do I add a check constraint to a table in MySQL?

To add a check constraint to a table, let us first create a table.

CREATE table yourTableName (
   Column_name1 datatyep,
   .
   .
   .
   .
   Column_name N datatype,
   check( condition)
);

The following is how you can check the age by creating a check constraint.

check(Age>=45)

Let us now create a table and while creating a table, we will add the above shown check constraint for age.

mysql>CREATE table addCheckConstraintDemo
-> (
-> Age int,
-> check(Age>=45)
-> );
Query OK, 0 rows affected (0.55 sec)

George John

Published on 20-Nov-2018 06:40:58

• Related Questions & Answers
• How do I remove a uniqueness constraint from a MySQL table?
• How do I alter a MySQL table column defaults?
• How do I detect if a table exist in MySQL?
• How can we check the indexes created by a UNIQUE constraint on a MySQL table?
• How can we add a FOREIGN KEY constraint to the field of an existing MySQL table?
• How do I add to each row in MySQL?
• How do I list all the columns in a MySQL table?
• How do I show unique constraints of a table in MySQL?
• How do I clone the structure of a table in MySQL?
• How can we drop UNIQUE constraint from a MySQL table?
• How do I show the schema of a table in a MySQL database?
• How to add a column in a table in MySQL?
• How add a unique key constraint to a column of a table in a database using JDBC API?
• How do I get the creation date of a MySQL table?
• How to add a primary key constraint to a column of a table in a database using JDBC API?