Alter Table MySQL

[Anon]

Hey. I am an idiot.. 🙂 I forgot a field in my table.. so I used:

Alter table jack add jack_address TEXT;

However..

I need it to be above jack_city and below jack_name. Right now its sitting at the bottom of the table. I really don't want that. So how do I move it?? Thank you.
Chad

[simonsky]

Alter table jack drop jack_address

Alter table jack add jack_address TEXT after jack_name

Broken Formula wrote:

Hey. I am an idiot.. 🙂 I forgot a field in my table.. so I used:

Alter table jack add jack_address TEXT;

However..

I need it to be above jack_city and below jack_name. Right now its sitting at the bottom of the table. I really don't want that. So how do I move it?? Thank you.
Chad