aysx Posted March 29, 2003 Share Posted March 29, 2003 ummm.. how do you set a default value in a mysql table? i want to change the column brianna so it has a default value of six, but i\'m using alter table clarence alter brianna set default six which doesn\'t seem to work... can anyone tell me why?[/code] Quote Link to comment Share on other sites More sharing options...
shivabharat Posted March 30, 2003 Share Posted March 30, 2003 alter table clarence ALTER brianna varchar(10) DEFAULT \'six\' NOT NULL, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.