Add new coulmn to databse from phpmyadmin

Here are the steps to add a new column to a database table in PHPMyAdmin:

Step 1: Log in to PHPMyAdmin

Open a web browser and navigate to http://your-server-ip-or-domain/phpmyadmin (replace your-server-ip-or-domain with your server's IP address or domain name). Log in with your database username and password.

Step 2: Select the database

In the PHPMyAdmin dashboard, select the database that contains the table you want to modify from the left-hand menu.

Step 3: Select the table

In the database structure section, select the table you want to add a new column to from the list of tables.

Step 4: Click on the "Structure" tab

Click on the "Structure" tab to view the table's current structure.

Step 5: Click on the "Add field" button

Click on the "Add field" button located at the top of the table structure section.

Step 6: Enter the new column details

In the "Add field" dialog box, enter the following details:

• Field: Enter a name for the new column (e.g., "new_column").
• Type: Select the data type for the new column (e.g., varchar, int, datetime, etc.).
• Length: Enter the length of the new column (if applicable).
• Default: Enter a default value for the new column (if applicable).
• Extra: Enter any additional information about the new column (if applicable).

Step 7: Click on the "Save" button

Click on the "Save" button to add the new column to the table.

Step 8: Verify the new column

Go back to the table structure section and verify that the new column has been added successfully.

That's it! You have successfully added a new column to a database table using PHPMyAdmin.