Question: what is the difference between null and not null in mysql?
Answer: NOT NULL means that the column can not have a NULL value for any record; NULL means NULL is an allowable value (even when the column has a foreign key constraint). ... Generally you want as many columns as possible to be NOT NULL because you want to be sure data is always there.