Different databases will behave a little differently (and it probably depends on the table setup a bit), but in general there’s no rule about having to specify each column. For example, in mysql you could do something as simple as:
INSERT INTO yourtable() values()
to just use the default values for all columns.
Regards,