List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 18 1999 2:23pm
Subject:Re: ADD Column
View as plain text  
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/
Thread
ADD ColumnPinkeshP18 Jun
  • Re: ADD ColumnPaul DuBois18 Jun
  • sysTablesStefan Vesterlund18 Jun
    • Re: sysTablesSasha Pachev18 Jun