Thanks for the tip: ALTER TABLE specs MODIFY food CHAR(30); does the trick! --- Thomas Vanhal <tom@xxxxxxxxxxxx> wrote: > Did you try a ALTER table? > ----- Original Message ----- > From: "Patrick Roane" <fojomo@xxxxxxxxxxxxx> > To: <php-windows@xxxxxxxxxxxxx> > Sent: Friday, January 28, 2005 11:50 AM > Subject: 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
