urgent !!!! need the right sql method to add new column into exist table
yossi avisror
Greenhorn
Joined: May 07, 2001
Posts: 4
posted
0
i would like to get the right sql method to add new column into exist table (i am using mysql server).
Daniel Dunleavy
Ranch Hand
Joined: Mar 13, 2001
Posts: 276
posted
0
Don't know mysql..but in oracle...alter table add colname char
yossi avisror
Greenhorn
Joined: May 07, 2001
Posts: 4
posted
0
thankes Daniel you realy helped me
David DeCesare
Greenhorn
Joined: May 25, 2001
Posts: 13
posted
0
One additional feature that MySQL has is the ability to add a new column next to an existing column (rather than being slapped at the end): ALTER TABLE tableName ADD newColumnName VARCHAR(32) NOT NULL AFTER existingColumnName Hope that helps.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: urgent !!!! need the right sql method to add new column into exist table
0
