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 is the maximum size of mysql database?

993

How do I download a mysql community server?

930

What is federated tables in mysql?

955

Can we store pdf files in mysql?

1034

How to show all tables with 'mysql'?

1062

How do I start mysql in ubuntu?

1090

How can you retrieve a portion of any column value by using a select query?

971

What is view in mysql?

1020

What happens if null values are involved in expressions?

1086

What mysql -u john -p command does?

1028

Can we write procedure in mysql?

986

What is root password?

967

What is database in php mysql?

1040

How do you know the version of your mysql server?

1226

What is ibdata1?

966