我想允许列为null,但不允许空字符串.
sqlite> create table foo (bar TEXT,CHECK(bar <> '')); sqlite> insert into foo values (NULL); sqlite> insert into foo values ('bla'); sqlite> insert into foo values (''); Error: constraint Failed