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?
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