1. Computing
About.com
PHP / MySQL

Discuss in my forum

Change MySQL Command

By , About.com Guide

Definition: Change is used to alter an existing column in a MySQL table. You can use change to rename a column by providing both the old column name, and the new column name. It is written as: alter table change [old column name] [new column name] varchar (30) ;
Also Known As: Change Column, Rename Column
Examples: 
 alter table colors change tone hue varchar (10) ;
This causes the column called "tone" to be renamed to "hue" on the table called "colors".
About.com
PHP / MySQL
  1. About.com
  2. Computing
  3. PHP / MySQL
  4. MySQL Commands
  5. Alter Table Change - MySQL Change - SQL Change