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. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
How to create a new table in mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
what is database black box testing? : Mysql dba
What is the default port for mysql and how it can change?
How do I install the latest mysql on ubuntu?
What is mysql installer?
How to delete a trigger in mysql?
What is the latest mysql version?
What is bdb (berkeleydb)?
How do I uninstall mysql connector?
Write a command to view mysql database table structure?
What command is used to delete the data from the table without deleting the table structure?
What is a query in mysql?
What is row level locking?