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

Is mysql free for enterprise?

848

How to create a new table in mysql?

977

How can you filter the duplicate data while retrieving records from the table?

839

Is Mysql query is case sensitive?

958

How do I drop a database in mysql?

1064

What is mysql protocol?

837

What is acid in mysql?

801

Write a query to retrieve a hundred books starting from 20th.

1458

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1078

What is the return type of mysqli_query?

803

What are the advantages of a procedure?

868

What is a longblob?

889

What is the use of mysqli_query?

834

List some comparisons operators used in mysql?

932

What is a text delimiter?

870