November 28th, 2000, 10: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...
November 28th, 2000, 11:59 PM
ALTER TABLE your_table ADD COLUMN new_column_name [COLUMN DEFINETIONS] AFTER column_name_to_put_new_column_after
ALTER TABLE mytable ADD COLUMN message VARCHAR(150) AFTER id
Look here for more info: http://www.mysql.com/documentation/m...ml#ALTER_TABLE
November 29th, 2000, 01:31 AM
i got it working already..thanks for your help!!!