Inserting a Column to preexisting table in phpmyadmin

Question

I want to add a column to preexisting table. Can I add it in between two existing columns? I am working on phpmyadmin.

Answer 1

Use the add new column after dropdown.

1. Select the database from the menu on the left.

2. Select the table by clicking on it's title column hyperlink.

3. Check the add new column after radio button and select the column you want to insert after in the drop down.

4. Click Add.

This video goes through the process http://www.youtube.com/watch?v=jZ72GCGWPQg

Answer 2

You want something like:

ALTER TABLE contacts ADD email VARCHAR(60);