SQL small white, I recently learn mysql, MAC version download cracked versions navicat premium, import the data table is an error code 1171, prompt the primary key cannot be null, but when I set the primary key no GouChu null value of the option, if the import data sheet does not set the primary key can be imported successfully, before the use of navicat for mysql trial version is not the problem, is also the same steps, now with navicat premiun appear online didn't find the solution, the problem for the great god told how to solve this problem,

CodePudding user response:

Primary keys are not free value, this is a theorem, none of navicat business, free if a certain columns of data values, will not be able to set the column is the primary key,

CodePudding user response:

That excuse me I use navicat import excel set as primary key how to choose

CodePudding user response:

reference 1st floor by the stars of a cold response:

free primary key can't value, this is a theorem, none of navicat business, if a certain columns of data values free, will not be able to set the column is the primary key,

I use that excuse me navicat import excel when primary key how to choose and set up

CodePudding user response:

reference Ren_Leo reply: 3/f

Quote: refer to 1st floor by the stars of a cold response:

free primary key can't value, this is a theorem, none of navicat business, if a certain columns of data values free, will not be able to set the column is the primary key,

I use that excuse me navicat import excel at how shall we choose and set the primary key

Data is repeated or null values, can not set the primary key,