Re: basic mysql question:

Thanks for the tip: ALTER TABLE specs MODIFY food CHAR(30); does the trick! --- Thomas Vanhal <tom@pmsa-inc.com> wrote: > Did you try a ALTER table? > ----- Original Message ----- > From: "Patrick Roane" <fojomo@sbcglobal.net> > 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