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 'mysqldump'?

1073

What is blob and text in mysql?

1172

How to convert character strings to numeric values?

1131

How do I change the max connection in mysql?

962

What is a heap table?

969

What is default schema in mysql?

935

How do I find mysql version in mysql workbench?

943

Can we rollback truncate in mysql?

1021

How to store values to array from mysql database in php?

946

What is a query in mysql?

998

What is the insert?

899

How to get the number of rows selected or affected by a sql statement?

921

What is the limitation of mysql?

969

can you elaborate on blob and text in mysql? : Mysql dba

897

What is limit in mysql?

873