MariaDB Error 1171 – ER_PRIMARY_CANT_HAVE_NULL

In this post, you’ll learn more about the MariaDB Error 1171 ER_PRIMARY_CANT_HAVE_NULL with the details of the error message and why you receive this error

Maria DB Error Description

MariaDB Error 1171 – ER_PRIMARY_CANT_HAVE_NULL with the sqlState 42000

Error Description for the MariaDB Error 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