PDA

View Full Version : making (or rather converting) a new hack, however... problem hehe

LoB
08-27-2001, 09:41 PM
how do you add a new column to a database when it contains data, for the hack to work there needs to be an extra field in the user table
LoB
08-29-2001, 03:32 PM
bump
urgent
Salkiri
08-30-2001, 12:25 AM
Here is the SQL statement that will add newcolumn after lastcolumn

ALTER TABLE user ADD newcolumn smallint(6) DEFAULT '1' NOT NULL AFTER lastcolumn