#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2011
    Posts
    7
    Rep Power
    0

    Add column to table in mysql


    hi. guys i use mybb as the forums for my site.
    i want to add a column named xuid in the mybb_users table so when users want to register in my site put their xuid that contains 16 digits and words and be saved in this column
    so please give me the code for adding the xuid column to the mybb_users table.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by raminr63
    so please give me the code for adding the xuid column to the mybb_users table.
    have you tried the mysql manual?

    ALTER TABLE mybb_users
    ADD COLUMN xuid VARCHAR(16)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo