Re: ADD Column

[Paul DuBois]

At 9:09 AM -0500 6/18/99, PinkeshP@stripped wrote:
>How do i add a column after specific column in existing table
>for example
>i want to add a column name "country" after the column "zip" in table name
>"info"

ALTER TABLE info ADD COLUMN column_definition_for_country AFTER zip


This is in the MySQL manual, chapter 7:

http://www.mysql.com/Manual_chapter/manual_Reference.html#ALTER_TABLE

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/