Error 1171: All parts of a PRIMARY KEY must be NOT NULL
Error Code
SQLSTATE
Error
Description
1171
42000
ER_PRIMARY_CANT_HAVE_NULL
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1170: BLOB/TEXT column used in key specification without a key lengthNextError 1172: Result consisted of more than one row
Last updated
Was this helpful?