Tutorial: phpMyAdmin
I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin
This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to copy a database table.
- Click the database table you wish to copy.
- Then click the Operations tab.
- When copying a table, you can choose to copy the table structure only, the data only, or both. Enter a name for the new table here, then click Go.
- Copying a table actually creates a new table altogether (that’s identical to the one we’re copying)….. so we have to give a name for the new table.
- That’s it! A new table has been created, and it is a perfect copy of the original. Both tables are now listed here.