Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • What is NOT NULL Constraint in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 546
    Comment on it

    In MySQL, the NOT NULL constraint is used to restrict a column to NOT accept NULL values.

    The NOT NULL constraint allows a column to always contains a value which means you cant not insert/update a record in a table without passing value for that column on which you have applied the NOT NULL constraint.

    The below statement doesn't allow to "id" column and "first_name" column to accept NULL values:

    Example

    1. CREATE TABLE emplyee
    2. (
    3. id int NOT NULL,
    4. first_name varchar(45) NOT NULL,
    5. last_name varchar(45),
    6. country varchar(45)
    7. );

    Hope this will help you :)

    mysql database not null constraint
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: