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
How do you kill a long running query in mysql?
Is mysql a scripting language?
What is mysqladmin flush hosts?
What is mysql server used for?
What is the difference between float and double?
What do you need to connect php to mysql?
What can I do with mysql?
What are the limitations of mysql?
How can we convert between Unix & MySQL timestamps?
What is trigger in mysql with example?
What is the datatype for password in mysql?
What does mysqli stand for?
Can you tell a way to know the number of days between the two given dates in php?
What are the 'mysql' command line options?
Explain about reporting services of MYSQL?