Inserting new fields into a table in PhpMyAdmin

In PMA, you can edit the table structure. Let's insert two fields into it - surname and salary.

To do this, find the input Add at the bottom of the table. You need to specify the number of fields in it - 2. To the right of it is a drop-down list in which you can select after which fields the new ones will be inserted. Let them be inserted as specified by default after the field name. Now click the button Go:

A field will open in which we can assign a name and data type to new lines:

We fill in our fields surname and salary, assigning the required data type to each of them. In order for the changes made to be saved, we click on the button Save:

After successfully saving the new data, the general structure of the table will be displayed. At the same time, the SQL query that was executed when inserting new rows will be displayed above it: