/SQL/How to add not null constraint in sql

How to add not null constraint in sql

ALTER TABLE table_name MODIFY column_name datatype NOT NULL;

Source: tutorialspoint.com

NOT NULL SQL

By default, a column can hold NULL values.
The NOT NULL constraint enforces a column to NOT accept NULL values.
This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field.

Sql NOT NULL in creating a table
CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255) NOT NULL,
    Age int
);

Similar codes

3 votes211 views1 answer
Set default today mysql
SQL
0 vote189 views3 answers
Insert query in ci
SQL
0 vote191 views2 answers
Oracle create tablespace autoextend
SQL
0 vote187 views1 answer
Delete first row in sql
SQL
2 votes168 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote172 views1 answer
Show all event schedular on mysql
SQL
1 vote191 views1 answer
Psql connect to another database
SQL
1 vote202 views2 answers
Drop table with constraints
SQL
0 vote172 views1 answer
Mysqldump ignore table
SQL
3 votes228 views2 answers
Brew restart mysql
SQL