Help  >  MySQL Database Manager > Performing Table Operations > Copying tables

Copying tables

When you copy a table, you have a number of considerations to make. You can choose to:

• copy just the structure (columns), just the data (records) or both (structure and data).
• include a "drop table" statement in the SQL query phpMyAdmin sends to the database; this will overwrite an existing table that has the same name as the copied table.
• check the auto_increment option to append the records of the copied table to the existing table; the starting auto_increment value (typically an ID field) will be one increment above the highest value in the existing table.
• switch to the copied table once the action has been performed.

To copy a table:

1. Enter a name for the table In the Copy table to input field. By default, the current name is used.
2. Check the desired options.
3. Click Go.