Add column to table in mysql

[raminr63]

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.

 

[vacunita]

[COLOR=#0022CC][b]ALTER TABLE[/b][/color] [COLOR=#882200][b]mytablename[/b][/color] [COLOR=#0022CC][b]ADD[/b][/color] [COLOR=#882200][b]column_name column_type[/b][/color];

NOTE: The user needs to have Altering privileges on the table in question.


----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[raminr63]

i use phpadmin.
i create a column and a XUID file in registration and member profile.

but after save the XUID column always is NULL ?!

what i can do?
how i can add "The user needs to have Altering privileges on the table in question".?

 

[raminr63]

why i can not edit my post?!
my means in this line :
i create a column and a XUID file in registration and member profile

filed not file

 

[vacunita]

I don't understand. If you add a new column that was not there before, the column is going to be empty until you insert values into it so all the rows will have Null in them, that is correct.

Just start adding values to the fields.

why i can not edit my post?!

Sorry, no edit feature here.

my means in this line :
[
i create a column and a XUID file in registration and member profile

Its a configuration for MYSQL, if you already created the column then its o.k. the user has the required privileges.



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech