Results 1 to 7 of 7

Thread: Rename Column

  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: Rename Column

    hi
    I want to rename column in mysql

    such as column A to column B in ISMWL table what would be the exact syntax in mysql
    Last edited by ankur02018; 07-06-07 at 09:41.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you wanting to do this in mySQL or SQL Server (as in your other thread here)?

    Please don't cross post - stick to the relevant topics
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Thread in SQL Server removed.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Cheers Poots - oh "wise" one
    As for the answer - look up ALTER TABLE statements in BoL - that'd be my first place to look.
    George
    Home | Blog

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    george, mysql's "BoL" is not known by that moniker

    we simply call it da manual or da docs
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Jun 2007
    Posts
    197

    Smile

    thanks all for your reply I got the correct syntax

    ALTER TABLE `TableName` CHANGE `ExistingColumnName` `NewColumnName` DataType ;

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by georgev
    Cheers Poots - oh "wise" one
    wtf is the wink for?













    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •