The problem with this is that you supply 5 values for 6 columns.
Apparently the SQL server cannot determine which value you're missing.**
Try using this statement:
Code:
insert into members set member_id=1, fname='firstname', lname='lastname', address='address', phone='12345'
This way you explicitly specify which values you're setting, and the server should take the default for all other columns.
**Think of it this way: if there are 2 columns with a default setting, how would the server know which value you
didn't specify?
Only for the case where colums-with-default-values equals the number-of-missing-values is there a 'correct' way to parse the statement.
HTH