If you aren't good with sql commands you could try one of the many gui interfaces that are out that, I use phpMysqlAdmin and Kmysqladmin (KDE) they work really great at alter tables.
Chuck Payne On 6/14/02 6:51 PM, "Peak Digital Productions" <[EMAIL PROTECTED]> wrote: > Thank you - I'd already looked there but somehow overlooked it. TGIF. > > Paul > > >> From: "William R. Mussatto" <[EMAIL PROTECTED]> >> Date: Fri, 14 Jun 2002 15:28:19 -0700 (PDT) >> To: Peak Digital Productions <[EMAIL PROTECTED]> >> Cc: [EMAIL PROTECTED] >> Subject: Re: alter column without dropping >> >> On Fri, 14 Jun 2002, Peak Digital Productions wrote: >> >>> Date: Fri, 14 Jun 2002 16:33:05 -0600 >>> From: Peak Digital Productions <[EMAIL PROTECTED]> >>> To: [EMAIL PROTECTED] >>> Subject: alter column without dropping >>> >>> The data going into one of my mySQL columns has suddenly changed, so I need >>> to >>> change the parameters of the column. >>> >>> Currently, it is varchar(32), I need to change it to varchar(128). >> See alter table command in the docs. >> >>> >>> Can I do that without dropping the column? >>> >>> Thanks, >>> Paul >>> >> >> Sincerely, >> >> William Mussatto, Senior Systems Engineer >> CyberStrategies, Inc >> ph. 909-920-9154 ext. 27 >> >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail >> <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php