Alter Table

[chavalis]

I want alter the table and add column to the table.The table has so much data.Can you help me how to do that?

[mark]

Create a new table with the desired schema. Copy the data from the old table to new using
insert into NEWTABLE select a,b,c,'NEWFIELDDEFAULTVALUE',d,e from OLDTABLE