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

What is mvcc in mysql?

948

How to create table show example

923

How to Set a root password if there is on root password.

1043

What is mysqladmin flush hosts?

922

What is mysql routine?

877

What is ibdata1?

860

How are mysql timestamps seen to a user?

974

Which statement is used to delete a table in MySQL.

875

What is prepare statement in mysql?

938

How do I zip a file in mysql?

947

Can mysql scale horizontally?

954

What is the default password for mysql?

861

How to convert character strings to numeric values?

1076

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

877

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1346