MySQL "alter table" syntax got problemI am trying to add a column into an existing table using ALTER TABLE table_name ADD COLUMN column_name column_definition FIRST another_column the FIRST keyword got syntax error. btw, i am using MySQL 4 Could anyone help to solve this problem? (more...)

actually ur this sql query only insert a new column at the end of the tablewhat i want is to insert a new column at the beginning of the table. And, i just found out that there is no problem with the keyword "FIRST" at all. I read the manual wrongly yesterday. ====================== ALTER [IGNORE] TABLE tbl_name alter_specification [, alter_specification] ... alter_specification: ADD [COLUMN] column_definition [FIRST | AFTER col_name ]......... ======================= So, to add a column at the beginning of the table, use "alter table my_table add column my_colunm column_definition FIRST". To add a column at any other place rather than the beginning of the table, use "table my_table add column my_colunm column_definition AFTER clolumn_B" (more...)