How can we change the name and data type of a column of a
table?
Answer Posted / ashish
o Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);
Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is mysql and why it is used?
How do I create a mysql username and password?
Why do we use preparedstatement?
Is mysql free download?
Is mysql good for big data?
What is delimiter in mysql trigger?
What is a left join mysql?
What are the disadvantages of stored procedures?
How to create table with same structure of student table in mysql?
What do I do if I forgot my mysql root password?
How many entries can mysql handle?
In how many ways we can retrieve data in the result set of mysql using php?
How many rows can be inserted in mysql at a time?
How set mysql root password?
Why do we use the mysql database server?