Reading Time: 2 minutes

When working on a database, you might find that more data should be added for each record but does not fit into any current field. Adding a new column into an existing database can help with that problem and is easy and straightforward to do with PhpMyAdmin.

This guide assumes that you have already logged in to PhpMyAdmin.We will go over how to copy a table and go over a few of the options PhpMyAdmin gives us.

Starting on the home page of PhpMyAdmin, click on the database name that the table we want to modify is in.

Then, click on the table name.

This page shows us the existing structure and in my case we see four existing columns: option_id, option_name, option_value, and autoload. To add a new column, click on the Structure tab up near the top of the page.

#tutorials #data management #database #mariadb #mysql #phpmyadmin