CODEWITHSUNDEEP
mysqlphpmyadmin
StrawhatLuffy
StrawhatLuffy

Reputation: 715

Inserting a Column to preexisting table in phpmyadmin

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

Upvotes: 23

Views: 65799

Answers (6)

LiveaLearn
LiveaLearn

Reputation: 187

Even if you have inserted a column in the MySQL, MySQL now provides an option to click on 'move columns' button below the table.

enter image description here

Upvotes: 0

Shemeer M Ali
Shemeer M Ali

Reputation: 1041

Yes, you can do that. See a "after" list box in the section. you can select after which field your new field need to be added.

Upvotes: 2

danmc
danmc

Reputation: 1201

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

Upvotes: 23

Maxime Lorant
Maxime Lorant

Reputation: 36181

I think this video can help you. With PHPMyAdmin

  1. Go to the page of the table you want to modify
  2. At the bottom of the page, select you desired column in "After" (at which position you want to add your column in the table)
  3. Validate and enter new column information

You can also do it via plain SQL, with a ALTER TABLE query:

ALTER TABLE mytable ADD column3 INT AFTER column1

Upvotes: 3

hjpotter92
hjpotter92

Reputation: 80653

The ordering of columns in MySQL isn't of much importance. As for adding a new column,

ALTER TABLE `tblName`
    ADD COLUMN `colName` INT(10) AFTER `firstCol`;

The AFTER clause defines the position where your new column will come.

Upvotes: 3

Vaughan Hilts
Vaughan Hilts

Reputation: 2879

You want something like:

ALTER TABLE contacts ADD email VARCHAR(60);

Upvotes: 5

Related Questions