Renaming database tables with phpMyAdmin

The purpose of this tutorial is to teach you how to rename database tables with phpMyAdmin. We will assume that you are already logged in to phpMyAdmin. For this tutorial, we will use a database with one table for an example.

Let's learn how to rename database tables. The left side of the main screen of phpMyAdmin is where you will find your database listed, with the table listed below the database name. The right side, a big white screen is where the actions take place. To start, select the database table you wish to rename in the list on the left hand side window. Select the table by clicking on it. The window on the right hand side will open up with the details about the table you have selected. Now, at the top of the right hand screen, click on the Operations button. This will open a list of actions you can perform on the table you have selected.

Scroll down to the box titled "Table Options". The first line is Rename table to with an empty box. Enter the new name for your table in this box. When you are done, click on the Go Button in the lower right corner. This will open the confirmation window, which shows that the table has been renamed. If you look in the panel on the left hand side, the table you selected is now showing the new name.

This is the end of this tutorial. You now know how to rename database tables using phpMyAdmin.

  • Email, SSL
  • 0 Kunder som kunne bruge dette svar
Hjalp dette svar dig?

Related Articles

Managing MySQL Databases With PHPMyAdmin

Let's learn how to Manage MySQL Databases with phpMyAdmin. This tutorial will assume that you...

How To Create A MySQL Database

Let's learn how to create a MySQL Database. MySQL Databases allow you to store lots of...

Importing databases and tables with phpMyAdmin

This tutorial is to teach you how to import databases and tables with phpMyAdmin. We will assume...

Inserting fields into database tables with phpMyAdmin

This tutorial is going to teach about the program phpMyAdmin, and how to Insert fields into...

Deleting tables in a database with phpMyAdmin

This tutorial is to teach you about specific operations in phpMyAdmin. We are going to learn how...