[sEnG]

After i have created a table with 4 columns, am i able to insert another column in between column 2 & 3 and not to the end of the column 4??
If there is pls also help me with the command to it...
thanks..

[Sepodati]

ALTER TABLE your_table ADD COLUMN new_column_name [COLUMN DEFINETIONS] AFTER column_name_to_put_new_column_after

i.e.

ALTER TABLE mytable ADD COLUMN message VARCHAR(150) AFTER id

Look here for more info: http://www.mysql.com/documentation/m...ml#ALTER_TABLE

---John Holmes...

[sEnG]

hi sepodaticreations
i got it working already..thanks for your help!!!