Code Forums - View Single Post

sde · 01-10-2003, 08:22 PM

if you are using phpmyadmin, it could be because those colums were not set null at first, and it automatically puts a '0' in there.

then when you make each field NULL, then it retains the default entry that was previously entered.

you will have to go back and type NULL as your default for that table.

now if you're not using phpadmin, .. then yes, it is possible .. the mysql code for adding a field to a table would be something like this:

Code:

ALTER TABLE 'db'.'table' ADD 'some_field' INT DEFAULT NULL;

01-10-2003, 08:22 PM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,505	if you are using phpmyadmin, it could be because those colums were not set null at first, and it automatically puts a '0' in there. then when you make each field NULL, then it retains the default entry that was previously entered. you will have to go back and type NULL as your default for that table. now if you're not using phpadmin, .. then yes, it is possible .. the mysql code for adding a field to a table would be something like this: Code: ALTER TABLE 'db'.'table' ADD 'some_field' INT DEFAULT NULL;