November 28th, 2000, 09:05 PM
-
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..
November 28th, 2000, 10:59 PM
-
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...
November 29th, 2000, 12:31 AM
-
hi sepodaticreations
i got it working already..thanks for your help!!!