Hi guys,

 

  Here's a quick one

 

I'm creating a table using the following :

 

#########

CREATE TABLE IF NOT EXISTS `test_table` (

  `test_field` INT NOT NULL DEFAULT -1 

);

#########

 

Note the default -1

I then do

 

#########

PRAGMA table_info (test_table)

#########

 

i'm getting the following

 

>>  "0","test_field","INT","99","NULL","0"

 

I was expecting -1 instead of NULL as default value, can anyone explain me
that ?

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to