Operations with multiple records in PhpMyAdmin

In PMA, you can also edit, copy, delete, and export multiple records at once. To do this, you must first select them. Let's figure out how to do this.

Let's say there are several records in our table. To select them all, you need to check the Check all checkbox:

After this, all records in the table will be selected:

You can remove the selection by clicking the checkbox again Check all.

You can also highlight specific entries by checking the boxes next to them:

Example . Editing entries

To edit multiple entries, click on the pencil icon:

Example . Copying records

To copy the selected records and paste them back into the same table, click on the following icon:

Example . Deleting records

To delete multiple entries, click the icon with the stop sign:

Example . Export records

Sometimes you may need to save the records from the table locally on your computer. To do this, you need to export them by clicking on the following icon:

After that, a page with export parameters will open. In the Export method section, select quick export. We will save our records in the .sql format. In the Rows section, select the Dump all rows value (dump, i.e. save, all rows):

At the end, we confirm the export by clicking on the Export button:

Practical tasks