to change the column name of a table

[abes_nitya]

Before you ask a question in this forum, you should check out our SQL Tutorial.For our SQL Tutorial: W3Schools SQL TutorialFor a SQL Reference: W3Schools SQL Quick Reference

Gr8 work 'kaijim'.Keep it up.

sir i have tried a lot to know the answer of this question , that "how to change the column name of a table" plz help me thanks.

[skym]

You will find the answer here: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html

[Jack McKalling]

Example:ALTER TABLE tablename RENAME newtablename

[abes_nitya]

Example:ALTER TABLE tablename RENAME newtablename

i don't want to change the table name... i want to change the column name of a tablebye

[aspnetguy]

use this

ALTER TABLE tablename  RENAME COLUMN currentColumnName TO newColumnName

This will change hte name of the column without effecting contraints or type

[abes_nitya]

use this

ALTER TABLE tablename  RENAME COLUMN currentColumnName TO newColumnName

This will change hte name of the column without effecting contraints or type

sir ,i could not stoped ....without giving u a thanks.i want to say u a heartest thanks.because i have to implement this query to my project.thanks

[aspnetguy]

well, your very welcome

[Jack McKalling]

Stupid of mine :)I knew that, If I only read it correctly

[guruparthi]

 

 

Alter table table_name change old_name new_name datatype(length)

For ex,

Alter table user change mail email varchar(50)

 

 

 

Reference: http://www.phponwebsites.com/2013/12/mysql-change-column-name.html