How can we change the name and data type of a column of a
table?
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 |
Post New Answer View All Answers
How do I edit a table in mysql?
Is postgresql better than mysql?
How to create a new table in mysql?
What is the difference between BLOB AND TEXT?
what is constraints? Also explain the different types of constraints?
What language does mysql use?
How many rows can mysql handle?
What is mysql_connect?
What is the query to display top 20 rows?
How to check if a record exists in a mysql database php?
How show all tables in mysql query?
Can varchar be primary key?
What is mysql database server?
What is root password?
What is mysql default database?