Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name and data type of a column of a
table?
- 9 Answers
- 26242 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / yogesh verma
Hi This is yOgEsH....!!
By this query we can change the data type of particular column :
ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2);
| Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
How do I show users in mysql?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
Where is the mysql config file?
I want to start and stop mysql on windows? How do I do that?
How do I start mysql database?
Is mysql free software?
How can I change database in mysql?
Can I copy mysql data directory?
In which language it is written?
How is mysql database stored?
What is the purpose of using ifnull() function?
How do I flush privileges in mysql?
What are the 'mysql' command line arguments?
What is row level locking in access?
How to convert character strings to numeric values?
