List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 13 2002 4:32pm
Subject:Re: mysql field name
View as plain text  
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 ...
>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

mysql field nameMeltem Demirkus13 Sep
  • Re: mysql field namePaul DuBois13 Sep
    • Re: mysql field namePaul DuBois13 Sep