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

ALTER TABLE info ADD COLUMN column_definition_for_country AFTER zip

This is in the MySQL manual, chapter 7:

Paul DuBois, paul@stripped
Northern League Chronicles:
ADD ColumnPinkeshP18 Jun
  • Re: ADD ColumnPaul DuBois18 Jun
  • sysTablesStefan Vesterlund18 Jun
    • Re: sysTablesSasha Pachev18 Jun