MySQL NOT NULL Constraint Guide

1 year ago
Liam
1 minute

In MySQL, you can add a non-null constraint by specifying the field attribute as NOT NULL when creating a table. For example, the following is an example of adding a non-null constraint when creating a table:

CREATE TABLE customers (
    id INT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(50) NOT NULL
);

In the example above, the fields “name” and “email” are defined as NOT NULL, which means they cannot be left empty when inserting data. Attempting to insert a null value will result in an error in MySQL.

bannerAds