Operations with tables in PhpMyAdmin

In PMA, you can perform various operations not only with records, but also with tables. For example, you can move, rename, copy and delete the selected table.

First, let's open the Operations tab:

It contains sections for performing operations. Let's look at working with them below.

Example . Moving a table

To move a table, you need to specify the name of the DB in which you will place the table in the left drop-down list. And in the right input, specify the name of the table to be moved:

Example . Renaming a table

To assign a new name to the table, go to the Table options section. And in it, specify a new name in the Rename table to input. Let the new name for the table be new_users:

You can confirm the renaming by pressing the Go button:

Example . Copying a table

To copy a table, you need to go to the section Copy table to (database.table):

In this section, specify the name of the DB to which the table should be copied. You can also set the following parameters when copying: copy only the structure, structure and data, only data. You can also delete the table in the section, add AUTO_INCREMENT for it and restrictions for data types. In addition, when copying, you can set the transfer of privileges and the transition to the copied table after this process is completed. Copying is confirmed by clicking the Go button:

Example . Deleting a table

The table can be deleted in a special section located at the very bottom of the page. To do this, select the link with the desired deletion parameter:

Practical tasks