Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name and data type of a column of a
table?
- 9 Answers
- 26562 Views
- Google, I also Faced
- E-Mail Answers
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 is 'mysqlshow'?
How do I start mysql manually?
How to Join tables on common columns.
How do I quit mysql?
What is the password of mysql?
How does mysql store dates?
How can you make a database as your current database?
What is a data directory?
What is indexing in mysql?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How to get a list of indexes of an existing table?
How to calculate the difference between two time values?
What is a definer?
What is difference between mysql and mysql server?
What is data node in mysql cluster?
