Hi This is yOgEsH....!! By this query we can change the data type of parti

How can we change the name and data type of a column of a
table?

Question Posted / yogesh verma

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

Please Help Members By Posting Answers For Below Questions

How many sql ddl commands are supported by 'mysql'?

1074

Why do we use mysql?

880

How do I install mysql on windows 10 64 bit?

871

What is the insert?

834

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4593

How do you know if your mysql server is alive?

989

Write a query to display current date and time?

883

How to copy data from one server to another using php?

978

Who developed mysql?

942

What are the advantages of MySQL when compared with Oracle?

879

How do I install mysql on windows 7?

938

How do I enable mysqli extension?

936

Is oracle mysql free?

821

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1259

How to delete an existing column in a table?

885