Editing a record in PhpMyAdmin

There are two options for editing records in PMA. We will look at them in more detail below.

Example

Let's change the name of our user. To do this, go to the Browse tab and click on the pencil icon:

This will open the Insert tab with inputs containing our entry data. Let's change the name to 'user+'. Then click the Go button:

If the changes have been applied, you will be redirected to the page with the table contents. Also, at the top of it, you will see the SQL query that worked:

Example

Changes can also be made via a direct SQL query in the SQL tab. For convenience, you can first use the UPDATE hint button:

Now a template will appear in the request field, into which you can make the necessary changes:

Let's fix the template for editing a post and replace the username with user++:

To confirm the changes, press the Go button:

After successfully making changes, you will see a page with the applied SQL query:

Practical tasks