List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 16 2002 4:06pm
Subject:Re: Adding new field BEFORE another
View as plain text  
At 11:01 -0500 9/16/02, Chris Boget wrote:
>I'm using MySQL 3.23
>
>In adding a new field to a table, I know you can use the AFTER
>keyword to place it after an existing field.  However, I've looked
>to see if there is a BEFORE keyword but I was unable to find it.
>Does it exist?  If not, is there a way to add a new field so that it
>becomes the first field in the table?

Yes, you can do that.

Use AFTER col_name to put the new column after an existing column.
Use FIRST to put the new column first.

>
>thnx,
>Chris

Thread
Re: Adding new field BEFORE anotherChris Boget16 Sep
  • Re: Adding new field BEFORE anotherPaul DuBois16 Sep
  • Re: Adding new field BEFORE anotherpeter.brawley16 Sep