Rename Column

ankur02018 · #1 (**permalink**) 07-06-07, 03:31

hi
I want to rename column in mysql

such as column A to column B in ISMWL table what would be the exact syntax in mysql

gvee · #2 (**permalink**) 07-06-07, 04:05

Are you wanting to do this in mySQL or SQL Server (as in your other thread here)?

Please don't cross post - stick to the relevant topics

pootle flump · #3 (**permalink**) 07-06-07, 04:06

Thread in SQL Server removed.

gvee · #4 (**permalink**) 07-06-07, 04:08

Cheers Poots - oh "wise" one

As for the answer - look up ALTER TABLE statements in BoL - that'd be my first place to look.

r937 · #5 (**permalink**) 07-06-07, 06:57

george, mysql's "BoL" is not known by that moniker

we simply call it da manual or da docs

ankur02018 · #6 (**permalink**) 07-06-07, 08:41

thanks all for your reply I got the correct syntax

ALTER TABLE `TableName` CHANGE `ExistingColumnName` `NewColumnName` DataType ;

pootle flump · #7 (**permalink**) 07-06-07, 09:13

Quote:

Originally Posted by georgev

Cheers Poots - oh "wise" one

wtf is the wink for?