Jump to content


Photo

Increasing Column Size


  • Please log in to reply
1 reply to this topic

#1 android6011

android6011
  • Members
  • PipPipPip
  • Advanced Member
  • 85 posts

Posted 07 December 2005 - 11:26 PM

I have a colum in table memberinfo named emailadd . It is only a VARCHAR(25), how can I change it to be like VARCHAR(35)?


#2 Cook

Cook
  • Members
  • PipPipPip
  • Advanced Member
  • 64 posts
  • LocationSingapore

Posted 08 December 2005 - 03:19 AM

[!--quoteo(post=325460:date=Dec 8 2005, 07:26 AM:name=android6011)--][div class=\'quotetop\']QUOTE(android6011 @ Dec 8 2005, 07:26 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
I have a colum in table memberinfo named emailadd . It is only a VARCHAR(25), how can I change it to be like VARCHAR(35)?
[/quote]

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']ALTER TABLE[/span] `mytable` CHANGE `mycolumn` `mycolumn` VARCHAR(35) [!--sql2--][/div][!--sql3--]
Cook




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users