Constraints Flashcards
1
Q
Cannot leave this column empty
A
NOT NULL
2
Q
Cannot have more than one of this in a column
A
UNIQUE
3
Q
Will be the presented value if left blank
A
DEFAULT ‘default_value’
4
Q
Automatically add a value one higher than the last for new rows
A
key_id DATA_TYPE AUTO_INCREMENT
