Why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY? My question is why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY? I thought that PRIMARY KEY's can't be NOT NULL by definition? Is it really necessary to set it to NOT NULL?
Explicitly setting the NOT NULL is simply an additional action to make this fact clear also for the non-experienced users. It doesn't hurt and you can safely ignore it.