How can we change the name and data type of a column of a
table?
Answer Posted / yogesh verma
Hi This is yOgEsH....!!
By this query we can change the data type of particular column :
ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2);
| Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
What does mysql flush privileges do?
How we can see all indexes defined for a table in mysql?
How to print message in mysql trigger?
How do I clear a mysql database?
How do I change the max connection in mysql?
How to shut down the server with 'mysqladmin'?
What is slow query log in mysql?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
How do I change a procedure in mysql?
How do I view data in mysql workbench?
Where does mysql store data?
What is session variable in mysql?
How to extract a unit value from a date and time?
Does adding an index lock a table?
What is the difference between unix timestamps and mysql timestamps?