excuse mr pls ALTER TABLE products ALTER COLUMN price TYPE numeric (10

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

Question Posted / szsad

Answer Posted / szsad

excuse mr pls
ALTER TABLE products ALTER COLUMN price TYPE numeric
(10,2);
uyah nanhi vhalta hai

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I edit a table in mysql?

894

Is postgresql better than mysql?

1033

How to create a new table in mysql?

1043

What is the difference between BLOB AND TEXT?

1146

what is constraints? Also explain the different types of constraints?

965

What language does mysql use?

887

How many rows can mysql handle?

938

What is mysql_connect?

946

What is the query to display top 20 rows?

1016

How to check if a record exists in a mysql database php?

888

How show all tables in mysql query?

926

Can varchar be primary key?

919

What is mysql database server?

961

What is root password?

907

What is mysql default database?

992