insert new columes

[little83]

dear all

if I have table has three columes already and each have some values inside already

and I want to add 6 columes extra for that table and put values 0 inside each of the new columes..

I used the sql query



ALTER TABLE mytable ADD columename int NULL

but these create columes with null values but I want to create with 0 values and I tried to replace Null by 0 but I had an error



any ideas

[LogicMechanic]

ALTER TABLE mytable ADD columename int NOT NULL

[little83]

this solution doesn't work..in adition I want to insert zero value

[ck9663]

set the default constraint...

-- CK

[little83]

what sql command for that??

[ck9663]

Here, read this

-- CK