Re: Union and NULL
Hi ,
Today I found some user comment in ALTER TABLE Documentation Page....
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
Check this one out.. ( Third Comment )
----------------
Posted by Radhakrishnan Ayyappanaicker on April 13 2004 2:41am [Delete] [Edit]
while adding primary key constraint on null allowable integer column, mysql assigns default value 0 iff one NULL value exists on that column else alter table will fail with error "Duplicate entry '0' for key 1"
----------------
Note that he has mentioned something like "mysql assigns default value 0 iff one NULL value exists on a Column(Null allowable Integer) made as Primary Key...
Hope this is useful ....
Regards,
Ram.
Subject
Written By
Posted
Re: Union and NULL
August 11, 2004 04:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.