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 is timestamp in mysql?
Can mysql handle big data?
How to include numeric values in sql statements?
How to get data from mysql in php?
What is mysql used for?
What is the difference between char and varchar?
How to enter microseconds in sql statements?
Which is better mysql or mssql?
What is meant by mysqli?
What command is used to delete the data from the table without deleting the table structure?
What is the password of mysql?
Why should I learn mysql?
How to create a trigger in mysql?
How do I start mysql in linux?
How to use 'mysql' to run sql statements?