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). Can I do that without dropping the column? Thanks, Paul
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
Re: alter column without dropping
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
Re: alter column without dropping
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