How can we change the name and data type of a column of a
table?
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 |
Post New Answer View All Answers
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?
How to convert dates to character strings?
How do I install mysql on windows 10?
What is mysql gpl?
What is the difference between truncate and delete in mysql?
What is the difference between truncate and delete?
Is mysql still relevant?
How can we find out which auto increment was assigned on Last insert?
How do I enable mysqli extension?
How do I truncate all tables in mysql?
Is sql and mysql same?
Explain about the architecture of MYSQL?
How can you see all indexes defined for a table?
How do you kill a long running query in mysql?
how you will Create a database on the mysql server with unix shell.