Rename a Table or Column in mysql

August 18th, 2011 § 0 comments

If you are a PHPMyAdmin or SqlBuddy user (like me 😉 ), then mostly probably you won’t be familiar with sql queries for rename a table or rename a column. So here I share the sql query to do those things via command line.

To rename the column:
To rename the table:
Add new column after a specified field:

Revath S Kumar [RSK]

- Rubyist / JavaScripter - Yeoman Team member - Open source enthusiast - Blogger @ PHPRepo and http://blog.revathskumar.com - Coder @ Whatznear - Google fanboy - jQuery lover

More Posts - Website - Twitter - Facebook - LinkedIn - Pinterest - Google Plus - YouTube