During the development lifecycle, we may decide on a name for a table and later want to rename it based on the usage of the table.
Let217;s assume that there is a TABLE with name TransportType and the new name has been identified as TransportTypes (observe the extra “s̶1; in the name), it is tedious to create a new table, copy all the records and delete the old table.
MySQL has a one step process to rename tables.
RENAME TABLE oldTableName TO newTableName
Following our example, it would look like:
RENAME TABLE TransportType to TransportTypes
thanks you RSS link
More link Blog tech
more link ADS
Blockchain, bitcoin, ethereum, blockchain technology, cryptocurrencies
Information Security, latest Hacking News, Cyber Security, Network Sec
Information Security, latest Hacking News, Cyber Security, Network Security
Blog! Development Software and Application Mobile
Development apps, Android, Ios anh Tranning IT, data center, hacking
Car News, Reviews, Pricing for New & Used Cars, car reviews and news, concept cars