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

Reply via email to