SQL question

[thoand]

In SQL, what does it mean when a field has the default value of:

-1

thanks in advance

Thomas

[jacob_kochi]

Consider you have a field with default value -1

In an insert command you doesn't specify a value for the field then it will be automatically assigned as -1

[bobthedog]

Unless of course the field is of an unsigned int type, in which case it cannot store negative numbers and you will probably just get the value 0 (or NULL depending on the database type and whether NULL is an allowed value in the column decleration!)

Sorry - thought I would add that to the mix, since my inability to read column declerations caused me a few moments confusion with the problem above this morning! 🙂