Copying a database table with phpMyAdmin

phpMyAdmin series

12. Copying a database table 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
FutureHosting Best Hosting in Ireland - Copying a database table with phpMyAdmin

Then click the Operations button
FutureHosting Best Hosting in Ireland - Copying a database table with phpMyAdmin

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
FutureHosting Best Hosting in Ireland - Copying a database table with phpMyAdmin

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
FutureHosting Best Hosting in Ireland - Copying a database table with phpMyAdmin

This is the end of the tutorial. You now know how to create a copy of a database table using phpMyAdmin

Ця відповідь Вам допомогла?

 Роздрукувати цю статтю

Також прочитайте

Creating tables in a database with phpMyAdmin

phpMyAdmin series 2. Creating tables in a database with phpMyAdmin This tutorial assumes you've...

Running SQL queries on a database with phpMyAdmin

phpMyAdmin series 9. Running SQL queries on a database with phpMyAdmin This tutorial assumes...

Exporting databases and tables with phpMyAdmin

phpMyAdmin series 7. Exporting databases and tables with phpMyAdmin This tutorial assumes...

Renaming database tables with phpMyAdmin

phpMyAdmin series 10. Renaming database tables with phpMyAdmin This tutorial assumes you've...

Deleting fields from database tables with phpMyAdmin

phpMyAdmin series 6. Deleting fields from database tables with phpMyAdmin This tutorial assumes...