A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



can I change the default value of a bit field from 0 to 1
Explain the problem. I indicated that 1 should be the default value of a bit field... but 0 comes up when I open the table...however I can save the record with a 1 in that field. I just don't want to have to keep putting in a 1 if I don't have to IDEAS?
mysql variations:
None

access
db2
mysql
oracle
postgres
sqlserver