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.