Insert new field

[prokhaled]

I have this table:

ID User
1 rt

How can I insert new field between ID & User ??

ID pwd User
1 5555 rt

[chrisjk]

again look at ALTER TABLE statement (http://www.mysql.com/doc/A/L/ALTER_TABLE.html)

[scoutt]

also if you use phpMyadmin you can insert a new field anywhere you want.