Warning This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0.Instead, the My SQLi or PDO_My SQL extension should be used.
In terms of security, any existing privileges that we granted to the old table must be manually migrated to the new table.
Before renaming a table, you should evaluate the impact thoroughly.
There may be a requirement where the existing data in a My SQL table needs to be modified. This will modify any field value of any My SQL table.
The following code block has a generic SQL syntax of the UPDATE command to modify the data in the My SQL table − The WHERE clause is very useful when you want to update the selected rows in a table.
See also My SQL: choosing an API guide and related FAQ for more information. If your AUTO_INCREMENT column has a column type of BIGINT (64 bits) the conversion may result in an incorrect value.
Instead, use the internal My SQL SQL function LAST_INSERT_ID() in an SQL query.
PDF (US Ltr) - 37.9Mb PDF (A4) - 38.0Mb PDF (RPM) - 37.3Mb HTML Download (TGZ) - 10.3Mb HTML Download (Zip) - 10.3Mb HTML Download (RPM) - 8.9Mb Man Pages (TGZ) - 216.8Kb Man Pages (Zip) - 329.6Kb Info (Gzip) - 3.4Mb Info (Zip) - 3.4Mb My SQL Backup and Recovery My SQL Globalization My SQL Information Schema My SQL Installation Guide My SQL and Linux/Unix My SQL and OS X My SQL Partitioning My SQL Performance Schema My SQL Replication Using the My SQL Yum Repository My SQL Restrictions and Limitations Security in My SQL My SQL and Solaris Building My SQL from Source Starting and Stopping My SQL My SQL Tutorial My SQL and Windows My SQL NDB Cluster 7.5 column definitions can specify the current timestamp for both the default and auto-update values, for one but not the other, or for neither.
Different columns can have different combinations of automatic properties.
Summary: in this tutorial, you will learn how to rename tables using My SQL RENAME TABLE statement and ALTER TABLE statement.