you are at Encyclopedia of SQL >> NOT NULL
NOT NULL
NOT NULL constraint enforces a column to NOT accept NULL values. It means that
performing INSERT INTO or UPDATE operation we have to provide some value into NOT NULL column
Składnia
CREATE TABLE `table_name`
{
`column_name1` data_type [NOT NULL],
`column_name2` data_type [NOT NULL]
...
}
Example
Create `people` table with columns for name, surname and evidence_id which
have to contain any value
query
CREATE TABLE `people`
{
`name` text NOT NULL,
`surname` text NOT NULL,
`evidence_id` int NOT NULL
}
[ wróć na górę strony ]
