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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
