ALTER TABLE table_name change OLD_COLUMN_NAME NEW_COLUMN

How can we change the name of a column of a table?

Question Posted / tushar

Answer Posted / tushar

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHAR(255) NULL;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how we will Show selected records sorted in an ascending (asc) or descending (desc).

551

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

516

What are the 3 main types of search queries?

459

How do I rename a mysql database?

498

How to add a new column to an existing table in mysql?

530

Can you tell the difference between ereg_replace() and eregi_replace()?

533

How do I start mysql in linux?

482

Is mysql workbench a dbms?

534

What is innodb_buffer_pool_size?

472

How do I install mysql on windows 7?

484

How is oracle different from mysql?

500

What is a text delimiter?

514

How to create a table index in mysql?

528

What do ddl, dml, and dcl stand for?

485

How to run a sql statement?

538