How can we change the name and data type of a column of a
table?
Answer Posted / m. ravindar
To Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);
| Is This Answer Correct ? | 63 Yes | 12 No |
Post New Answer View All Answers
What are the types of database engines available in mysql?
Write a query to create a database and a table?
What is append query?
Can mysql and mariadb coexist?
What, if a table has one column defined as TIMESTAMP?
How to see the create table statement of an existing table?
What is relational database in mysql?
How do I delete a row in mysql?
Is mysqli deprecated?
What is orm in mysql?
How To see all the tables from a database of mysql server.
What is deterministic in mysql?
What you can use regular expression for in mysql? Support your answer with an example?
What is the difference between char and varchar?
How do I select a database in mysql workbench?