Jump to content


Photo

set default


  • Please log in to reply
1 reply to this topic

#1 aysx

aysx
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 March 2003 - 04:55 AM

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]

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 30 March 2003 - 01:53 AM

alter table clarence ALTER brianna  varchar(10) DEFAULT \'six\' NOT NULL,

Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users