Ah, yes you are correct. Thank you for pointing me in the right direction. I will endevour to prevent my ID10T errors from showing up here in the future. Thank you again.
----- Original Message ----- From: "Brian Reichert" <[EMAIL PROTECTED]> To: "Shaun Bramley" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 6:20 PM Subject: Re: Fw: Query to update column length > On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote: > > Hi all, > > > > I am writing an application that requires my application to possibly update > > the length of a char field while data is being imported into the db. First, > > can I update the size/type of a column using UPDATE? Would someone be > > willing to give me an example? > > I beleive 'UPDATE' updates records within a table, and 'ALTER TABLE' > affects the characteristics of the table itself. > > > thank you > > > > Shaun > > > > filter: mysql > > -- > Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> > 37 Crystal Ave. #303 Daytime number: (603) 434-6842 > Derry NH 03038-1713 USA Intel architecture: the left-hand path > > --------------------------------------------------------------------- > 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