mySQL rename table

One of the (few) downsides of  phpMyAdmin (at least the version I use) is that it doesn't support the mySQL rename table function.

It is very simple to use this function through the SQL tab in phpMyAdmin (or any other direct interface with mysql). Say you want to change the name of the table from "tbl_oldtable" to "tbl_newtable" then this would be the code:

RENAME TABLE tbl_oldtable TO tbl_newtable

Simple huh! Right with that duty to my readers and hopefully my natural search traffic... (these mySQL posts tend to do pretty well) I am off to drink more cabernet sauvignon :)

Comments

[Stomgatz]

what I like the most is that it does not require much time to change it, but if you want to do something else, you must check all the code to prevent a mistake.

[yiwu fair]

Nice collections!!! great source….Thanks for the post! ??

[Generic Viagra]

This program is excellent even at the beginning that I installed in my computer it didn't work very well but it comes to change and now it is perfectly.

[generic viagra]

what I like the most is that it does not require much time to change it, but if you want to do something else, you must check all the code to prevent a mistake.

[buy elimitecream]

After spending years on the Soap circuit, Tamara is happy to take the stage again and to be involved in a talented young playwright’s genesis.

[buy duricef]

Thanks, this definitely helped me too.
I restored a database created on a Windows version of MySQL to a linux server which is case sensitive, causing it to tell me my tables didn't exist.
You saved me having to edit 120 pages of code :-)

[buy doxycycline]

Thanks, this definitely helped me too.
I restored a database created on a Windows version of MySQL to a linux server which is case sensitive, causing it to tell me my tables didn't exist.
You saved me having to edit 120 pages of code :-)

[generic cialis]

there are different views on this topic
I think what best we can do i s tell it first and then give a review of weight

[viagra online]

Thanks, this definitely helped me too.
I restored a database created on a Windows version of MySQL to a linux server which is case sensitive, causing it to tell me my tables didn't exist.

[buy kamagra]

After spending years on the Soap circuit, Tamara is happy to take the stage again and to be involved in a talented young playwright’s genesis.