Deleting a record in PhpMyAdmin

You can also delete a record from a table using the PMA icon and through a direct SQL query. Let's look at these methods.

Example

To delete our user, we need to go to the Browse tab and click on the icon with the stop sign:

After this, a window will appear to confirm deletion:

We click on the button OK and we will get back an empty table:

Example

Now let's delete our record using an SQL query. In the SQL tab, click the DELETE hint button and insert the required data into the template:

Confirm the deletion by pressing the Go button. After that, a window will appear to confirm the deletion:

We click on the button OK and the executed SQL query will be returned to us:

Practical tasks