In MySQL, you can easily do it.

ALTER TABLE table1
ADD columnx VARCHAR(100)
AFTER column2;

所有跟帖： 

• oh, I love it. But t-sql doesn't support the key "after" ..:) -戲雨飛鷹- ♀ (0 bytes) () 04/27/2009 postreply 12:38:32

• then I don't know. -竹杉林- ♂ (0 bytes) () 04/27/2009 postreply 12:51:33

• Don't you hint t-sql supports the key "before"? haha. -竹杉林- ♂ (0 bytes) () 04/27/2009 postreply 12:52:42