How to Rename a MySQL Table Using PHP 


               


How to Rename a MySQL Table Using PHP



PHP







In this article, we show how to rename a MySQL table using PHP.

We rename a table using PHP to write the MySQL query to rename the table.





So the above is the MySQL code to rename a table named Java to PHP.

So the original name of the table is Java and we rename the table to PHP. The table will now be called PHP.

We'll now show how to tie this in completely with the full PHP code to rename a table.



So, first, we must connect to the database.

After we do this, we create a variable named $rename. This $rename variable is set equal to a mysql_query() function that has the parameter "ALTER TABLE Java RENAME TO PHP". This renames the existing table Java in our database to PHP.

If the table name is entered into a variable, instead of putting the table name directly into the DROP TABLE query statement, put the variable instead.

nd this is all that is needed to rename a MySQL table using PHP.


Related Resources

How to Create a MySQL Table Using PHP

How to Select a Table from a MySQL Database

How to Check if a MySQL Table Exists Using PHP

How to Show All Tables of a MySQL Database Using PHP

How to Delete a MySQL Table Using PHP

How to Add a Column to a MySQL Table Using PHP

How to Rename a Column of a MySQL Table Using PHP

How to Delete a Column of a MySQL Table Using PHP

How to Set the Default Value of a Column of a MySQL Table Using PHP

How to Insert Data into a MySQL Table Using PHP

How to Delete a Row of a MySQL Table Using PHP

How to Delete All Rows of a MySQL Table Using PHP

How to Insert Data Into a Table of a MySQL Database From an HTML Form Using PHP

How to Update a Value in a MySQL Table Using PHP

How to Copy a Table Definition in MySQL Using PHP

HTML Comment Box is loading comments...