Inserting a NULL value instead of a 0

[i3bargon]

I am storing nba scores into a database. I would like the ability to store a value of NULL into a database. The deafault value for int types for mysql is 0. For what i need 0 is a valid entry becasue a team could have a score of 0. But if i havent entered a score for that team i dont want a default value of 0 becasue in my case their score wasnt 0, it just hasnt been entered yet. So if a score hasnt been entered yet then i want null if the team score has been enetered and they didnt score any points then i want a null.

Is this possible with the ability to test what value was returned. For instance will i be able to test if a value returned was null. if it wasnt null then it must be >= 0.

Thanks.

[Sxooter]

Have you tried:

insert into table (team_id, score) values (1,NULL);

for inserting? And then a query like:

select id, sum(score), avg(score) from table group by id

SHOULD do the math right. But I don't use mysql, so if they get the math wrong, I don't know what to tell you other than to swtich to Postgresql. Which I know gets the math right.