Thanks for the tip: ALTER TABLE specs MODIFY food CHAR(30);
does the trick! --- Thomas Vanhal <[EMAIL PROTECTED]> wrote: > Did you try a ALTER table? > ----- Original Message ----- > From: "Patrick Roane" <[EMAIL PROTECTED]> > To: <php-windows@lists.php.net> > Sent: Friday, January 28, 2005 11:50 AM > Subject: [PHP-WIN] basic mysql question: > > > >I was wondering if there is a quick way to change > the > > value of my VARCHAR from 10 to 30 characters w/out > > having to drop and recreate the column? > > > > > > > > thanks- > > > > ===== > > > > ---------------- > > "forget your lust for the rich man's gold. All > that you need, is in your > > soul. You can do this if you try. All that I want > for you my son, is to be > > satisfied" > > > > ~ Lynard Skynard > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > ===== ---------------- "forget your lust for the rich man's gold. All that you need, is in your soul. You can do this if you try. All that I want for you my son, is to be satisfied" ~ Lynard Skynard -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
