SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Mysql command

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Mar 2002
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql command

    I want to add to extra columns to an existing table in the database. What is the command or for doing it. Thanks

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    ALTER TABLE table ADD column_name create_definition [FIRST | AFTER other_column_name]
    the optional FIRST or AFTER other_column is if you want the new column in a certain "place." by default, the new column will be added to the end of the table.

    reference: www.mysql.com/doc/A/L/ALTER_TABLE.html
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


Bookmarks

Posting Permissions

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