Page 1 of 1

mysql Default automatically becomes 0??

Posted: Tue Feb 08, 2005 11:23 am
by mohson
does anyone know why when I change a column in my mysql table it automatically generates a default of 0 for that particular column I dont set it it just generates itself why would this happen

this is what I do

їcode]
ALTER TABLE organisations org_id org_id int(11) not null
ї/code]

why would this make the default 0??

any ideas

Posted: Tue Feb 08, 2005 11:24 am
by feyd
it's an integer. zero is the default value of an integer.