Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name of a column of a table?
- 7 Answers
- 11128 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandrakant agrawal
ALTER TABLE <owner_name.tab_name> RENAME COLUMN <old_name>
TO <new_name>;
We can also modify the datatype,size of the column using
command alter table
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What are the different mysql database engines?
What are different types of queries?
How many triggers are possible in mysql?
What are the objects can be created using CREATE statement?
What is the difference between MyISAM Static and MyISAM Dynamic?
Explain the difference between procedure and function in mysql?
What is mysql and why it is used?
Is mysql a server or database?
How can you import tables from a sql file into a database by using the mysql client?
What is mysql database server?
What is a select query?
What is mysql connection limit?
What is the command used to create a database using php and mysql?
What are all the Common SQL Function?
How can we encrypt and decrypt a data presented in a table using mysql?
