Re: mysql field name

[Paul DuBois]

At 10:52 -0500 9/13/02, Paul DuBois wrote:
>At 18:33 +0300 9/13/02, Meltem Demirkus wrote:
>>  hi,
>>  can anybody tell me in mysql how  I can change a field's name...
>
>ALTER TABLE tbl_name CHANGE ...
>or
>ALTER TABLE tbl_name MODIFY ...


Ach.  My answer is wrong, of course.  MODIFY is for changing the definition
of a column *without* renaming it.  CHANGE allows you to rename the column
as well.

>
>>
>>  thanks a lot ...
>>
>>meltem demirkus