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

What does mysql flush privileges do?

888

How we can see all indexes defined for a table in mysql?

891

How to print message in mysql trigger?

1455

How do I clear a mysql database?

907

How do I change the max connection in mysql?

911

How to shut down the server with 'mysqladmin'?

929

What is slow query log in mysql?

1044

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

1279

How do I change a procedure in mysql?

950

How do I view data in mysql workbench?

968

Where does mysql store data?

833

What is session variable in mysql?

922

How to extract a unit value from a date and time?

904

Does adding an index lock a table?

914

What is the difference between unix timestamps and mysql timestamps?

974