Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 09-15-2012, 06:00 PM   PM User | #1
raminr63
New to the CF scene

 
Join Date: Sep 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
raminr63 is an unknown quantity at this point
Add column to table in mysql

hi. guys i use mybb as the group creator 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.
raminr63 is offline   Reply With Quote
Old 09-15-2012, 09:38 PM   PM User | #2
Fou-Lu
God Emperor


 
Fou-Lu's Avatar
 
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Posts: 15,635
Thanks: 4
Thanked 2,448 Times in 2,417 Posts
Fou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to all
ALTER TABLE mybb_users ADD COLUMN xuid char(16) assuming that when you mean 16 digits and words you mean 16 characters.
For more reference: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
Of course you'll need to write the PHP code to actually do something with it.
Fou-Lu is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 01:54 PM.


Advertisement
Log in to turn off these ads.