Help center

Changing a field in a database table with phpMyAdmin

Updated November 18, 2026

This article shows how to change a field (a column) in a database table with phpMyAdmin. It assumes you are already signed in to phpMyAdmin.

phpMyAdmin has two areas. The left side lists your databases, with their tables under each one. The right side is where details of the database or table you choose appear, and where you do your work.

Before you start, be aware that changes to a field can affect the data already stored in it. For example, shortening a field's maximum length can cut off longer values. If the data matters, make a backup first.

  1. In the left side, select the table you want to change. The right side shows the table's details, including a list of all its fields.
  2. Find the field you want to change.
  3. Tick the box at the start of that field's row.
  4. Choose the Change button below the list. The article's older version describes it as a pencil icon.
  5. The selected field opens on its own. Make the changes you need.
  6. Choose Save.

phpMyAdmin then confirms that the table was changed and shows the result.

To go back to the main screen, choose the Home button in the left side, below the phpMyAdmin name.

If something goes wrong, or you need help with your database, open a ticket from our client area and tell us what you were changing.

Still stuck?

Sign in and open a ticket, and we'll help.

Sign in and open a ticket