# Modifying fields in database tables with phpMyAdmin

> Learn how to edit a field in a database table - change its name, type, length or default - using phpMyAdmin in cPanel.

Source: https://www.kualo.com/knowledgebase/cpanel-databases/modifying-fields-in-database-tables-with-phpmyadmin
Updated: 2026-06-11

---

As your needs change, you may want to adjust a field in a table - make a text field longer, change its data type, rename it, or set a different default. phpMyAdmin lets you edit any field without writing SQL. This guide shows how.

## Before you start

Open phpMyAdmin from the **Databases** section of cPanel, click your database, then click the **table** that contains the field. New to phpMyAdmin? See [Becoming familiar with databases in phpMyAdmin](/knowledgebase/cpanel-databases/becoming-familiar-with-databases-in-phpmyadmin).

## Change a field

1. With the table open, click the **Structure** tab. You will see a list of the table's fields, each with a **Change** link in the Action column.
2. Click **Change** next to the field you want to edit.
3. Adjust the settings as needed. For example, to allow longer phone numbers you might increase the **Length/Values** of the `phone` field from `20` to `30`. You can also change its **Name**, **Type**, **Default** value, or whether it allows `NULL`.

   ![Editing the phone field and changing its length to 30](https://kb-cdn.kualo.com/98/a7/98a7c99b9a7f6958198983664903e456d37f7120.png)

4. Click **Save**.

phpMyAdmin applies the change and returns you to the **Structure** view, where the field now shows its updated definition.

![The structure showing the phone field updated to varchar(30)](https://kb-cdn.kualo.com/cb/28/cb28a6b033ffa3dc982f3a82b9eadb3bb0eba3ab.png)

:::warning
Changing a field's **Type** can alter or truncate existing data - for example shortening a `VARCHAR`, or switching text to a number. If the table already holds data, [export a backup](/knowledgebase/cpanel-databases/exporting-databases-and-tables-with-phpmyadmin) before making big type changes.
:::

To add a brand-new field instead, see [Inserting fields into database tables](/knowledgebase/cpanel-databases/inserting-fields-into-database-tables-with-phpmyadmin); to remove one, see [Deleting fields from database tables](/knowledgebase/cpanel-databases/deleting-fields-from-database-tables-with-phpmyadmin).

If you need a hand, our support team is available 24/7 - just [open a support ticket](/knowledgebase/getting-started/how-to-create-a-support-ticket-in-mykualo).


---

_Source: Kualo Knowledgebase — https://www.kualo.com/knowledgebase/cpanel-databases/modifying-fields-in-database-tables-with-phpmyadmin · © Kualo Ltd._