Knowledgebase

MySQL Alter Table - How to rename table names and column names in mysql ?

If you have access to a web administration tool like phpAdmin then you can use that to rename (alter) table and column names.
TAKE A BACKUP FIRST

To update the definition of a database table directly through MySQL then ...
TAKE A BACKUP FIRST

How to Rename an MySQL Table

RENAME TABLE oldtable_name TO newtable_name;

How to Rename a MySQL Column

ALTER TABLE table_name CHANGE oldcolumn_name newcolumn_name oldtype(oldsize);

How to Change the type/definition of a MySQL Column

ALTER TABLE table_name CHANGE column_name column_name newtype(newsize);

Add to Favourites    Print this Article

How can I RESTORE a MySQL database from the command line? (Views: 2272)

How do I move a MySQL Database from one host to another using phpMyAdmin ? Backup and Restore using phpMyAdmin. (Views: 16150)

Why does my PHP/MySQL based website / blob / forum / wiki show MySQL errors ? (Views: 2387)

How do I use a Microsoft Access database on Windows Plesk Hosting. (Views: 9336)

How do I backup and restore my Website and Databases. (Views: 2351)