Hi All, I have the table is defined as below: CREATE TABLE `signature` ( `sig` char(50) NOT NULL, `id' bigint(20) default '0', .... But I have ran the folowing command: .output mySelect select * from signature; then I didn't see NULL values in the mySelect file at all But I ran the following command: .output myDump .dump signature then I viewed the file it has the following NULL values INSERT INTO "signature" VALUES('573535428650752000',345049073990,1294,365,230296,414,1245183707,2,'0'); INSERT INTO "signature" VALUES(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); even though sig is defined as NOT NULL but why I have NULL for some of these insert statement in my dump but not in select. Thanks, JP
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users