MySQL Forums
Forum List  »  Knowledge Base

Struck in the Query
Posted by: sivaprasad adusumalli
Date: August 04, 2009 07:35PM

Hi ,

I am new to this forum. I struck in query. In my existing table i have two columns. Those two columns default value is showing as 'null' . but i need to change it as empty. Can any body help on this query. I wrote like this but it's not changing default value from 'null' to empty.

 ALTER table t1 ALTER COLUMN c1 set default 'NOT NULL';


thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Struck in the Query
2820
August 04, 2009 07:35PM
1375
August 25, 2009 03:31AM


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.