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
- 26292 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 many mysql connections can handle?
what is the difference between gui testing and database testing? : Mysql dba
How do I view mysql logs?
Is mysql free software?
What is database clustering in mysql?
What is striped backup
How can you take the backup and restore a mysql database using php?
Can we create table in stored procedure?
How do I truncate all tables in mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is maximum table size in mysql?
How do you shutdown a mysql database?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How to return query output in html format?
How do I install mysql on windows 10 64 bit?
