How can I edit a SQL-database?

If you go to phpMyAdmin, you will get a list of all tables of the database on the left side. On the right side you will get a table with the same table-names as in the list with some more details.

You find different possibilities to edit the database in the column Action (fig.1).


Among others, you also see how many records are in the table, the type and the size of the table.

Click the first icon in the column Action to see the content of the table (fig.1). All fields and their content will be shown. With a click on the pencil-icon, you can edit the content of a field. With a click on the red X-icon, you can delete the whole field (fig.2).


To see the structure of a table, you have to click the second icon in the column Action (fig.1). You see the details for all fields, like the type of the field or if it contains the primary-key etc.. Beside other icons you will find the pencil-icon again to edit the structure of the field, and the red X-icon to delete it (fig.3).


The key-icon (fig.3 ➀) is used to set a primary-key. A primary-key explicitly identifies a data record. With the red U-icon (fig.3 ➁) you can define, that the field has to be unique. So the content of the field may not be replicated in another one. To get to know, which further possibilities for structer-settings you have and which data types you can choose from, please read the 
FAQ â€šHow can I create a table?’. You have two possibilities to create a new field. The first one is to click the fourth icon in the column Action (fig.1). You also find a box with the title Add field(s) in the area which just got described. You can also define, where the field should be inserted in the table.

The third icon in the column Action(fig.1) is used for searching within the particular table. E.g. you can check, how many errors have occured in the field etc.. You find the Search by an exemplary value beneath. In the column Operator, you can choose, how the system should search. E.g. for data sets which are identic with the value you entered (=), for data sets which are identic or less than the value (<=), or for data sets which are not like the value (NOT LIKE or !=). At the column Value enter your exemplary value.

The dustbin-icon in Action (fig.1) is for clearing the whole table. The table persists, however. To delete the whole table, click the last icon, the red X.