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

Explain timestamp?

590

Does mysql use t sql?

578

How can you calculate the sum of any column of a table?

515

What are the similarities between a function and a procedure?

455

Is mysql a scripting language?

474

Is mysql relational database?

475

How to enter boolean values in sql statements?

545

what are the different tables present in mysql? : Mysql dba

472

How To see all the tables from a database of mysql server.

579

Write a query to stop mysql in unix

621

How do I delete a row in mysql?

485

What are slow queries?

484

What is flush privileges in mysql?

524

How do I assign a variable in mysql?

479

What is current version of mysql?

460