To Change Name of Column: Sy: Alter Table <Table Name> Change <Ol

How can we change the name and data type of a column of a
table?

Question Posted / m. ravindar

Answer Posted / m. ravindar

To Change Name of Column:
Sy: Alter Table <Table Name> Change <Old ColumnName> <New
ColumnName>;
Ex: Alter Table Test Change EmpId EID varchar(5);

Is This Answer Correct ?

17 Yes

19 No

Please Help Members By Posting Answers For Below Questions

What is mysql database server?

479

How to calculate the difference between two dates?

478

How many columns can be used for creating Index?

569

Does mysql support nosql?

469

How many threads can mysql handle?

496

What ascii 31?

509

Does mysql use t sql?

569

How to define numeric 9(3) in db2 table without decimal point??

2389

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

509

What is the default port number of mysql?

494

What is sharding in mysql?

499

Is mysql deprecated?

456

What are the security alerts while using mysql?

569

How is data stored in mysql?

487

How many ways to get the current time?

504