sqlite - 为什么 sqlite 在使用 create table 时会在任何带有 NULL 的行处停止（之后不再接受任何插入语句）？

Question

我试图使用 SQLite 创建这个表，但它只创建了前 6 行，之后它因为 NULL 而停止

create table manufacturing_facilities ( 
    company nvarchar(25) NOT NULL,
    countryID nvarchar(3) NOT NULL,
    number_of_locations integer NULL,
    Primary Key(company, countryID));

insert into manufacturing_facilities values('Intel','USA',8);   
insert into manufacturing_facilities values('Intel','ISR',1);   
insert into manufacturing_facilities values('Intel','CHN',3);   
insert into manufacturing_facilities values('Intel','VT',1);    
insert into manufacturing_facilities values('TEVA','ISR',60);   
insert into manufacturing_facilities values('TEVA','USA',20);   
insert into manufacturing_facilities values('TEVA','RUS',NULL); 
insert into manufacturing_facilities values('TEVA','IND',1);    
insert into manufacturing_facilities values('TEVA','DE',NULL);  
insert into manufacturing_facilities values('TEVA','JPN',1);    
insert into manufacturing_facilities values('TEVA','UK',2); 
insert into manufacturing_facilities values('Tesla','USA',1);   
insert into manufacturing_facilities values('Tesla','CHN',1);   
insert into manufacturing_facilities values('Toyota','JPN',16); 

我不确定在这种情况下该怎么办？

标签： sqlite