if a table contains data can you add extra colmn(sp?) to the database... i have a VBulletin set up but the userfields table only has space for 3 userfields, one of which is used but i want to add more because the number of hacks im adding to it will require at least 6 user defined fields... is there any way to do this? any help would be greatly appreciated as i dont want to reset the entire database for 1 hack :-)
What database are you using? Most databases can use the syntax of ALTER TABLE <tablename> ADD COLUMN <column name> <column type> <column options> .. hope that helps!
Chris King
i'm using MQSql, however, what will happen to the row's if i add a column to an existing table with data in it?
Well, it depends on the system, but if you add a coulumn and set it to NULL also give it a default value to avoid error, if you set it to NOT NULL and with no DEFAULT then it will be NULL :-P
