List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 24 1999 2:13pm
Subject:Re: Alter table command
View as plain text  
On Fri, 1999-09-24 09:55:07 -0400, David Siebert wrote:
> Does anyone know the syntax for the alter table command to change a
> varchar column's width? The docs for MYQL had examples of every
> fucntion but that.

Changing the column width is not different to any other change of
column type ...

  ALTER TABLE yourtable MODIFY fieldname VARCHAR(30) ...;

(instead of 30 you write the new field width, of course)

Just curious:  what made it so difficult for you to get that?

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Alter table commandDavid Siebert24 Sep
  • Re: Alter table commandMartin Ramsch24 Sep
  • Re: Alter table commandBob Kline24 Sep
RE: Alter table commandDarren L Sweeney24 Sep