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
How many sql ddl commands are supported by 'mysql'?
Why do we use mysql?
How do I install mysql on windows 10 64 bit?
What is the insert?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
How do you know if your mysql server is alive?
Write a query to display current date and time?
How to copy data from one server to another using php?
Who developed mysql?
What are the advantages of MySQL when compared with Oracle?
How do I install mysql on windows 7?
How do I enable mysqli extension?
Is oracle mysql free?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
How to delete an existing column in a table?