MySQL "alter table" syntax got problem
所在版块：求学狮城 发贴时间：2004-05-12 16:06

用户信息
复制本帖HTML代码
高亮: 今天贴 X 昨天贴 X 前天贴 X 
I 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?
.
欢迎来到华新中文网，踊跃发帖是支持我们的最好方法!

Put your OWN COOL signature here!
　相关帖子 我要回复↙ ↗回到正文
MySQL "alter table" syntax got problem － 喔喔 　2004-05-12 16:06 (309 bytes , 532reads )
alter table my_table add column my_colunm varchar(eg) default "default"; － MrDJay 　2004-05-13 12:01 (0 bytes , 251reads )
actually ur this sql query only insert a new column at the end of the table － 喔喔 　2004-05-14 09:25 (799 bytes , 214reads )
ic, sorry － MrDJay 　2004-05-14 11:16 (104 bytes , 161reads )