How can we change the name of a column of a table?
Answer Posted / vipul dalwala
ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHCHAR(100) NULL;
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Is mysql open source?
What are Heap tables?
Define REGEXP?
How to returns the columns and column information pertaining to the designated table.
using primary can we relate two table, with out foreign key?
What is the difference between float and double?
What is acid in mysql?
What are the advantages of mysql?
Why use mysql procedures?
How MySQL Optimizes DISTINCT?
What command is used to delete the data from the table without deleting the table structure?
Can I use mysql for free?
How can you change the password of a mysql user?
What are features of mysql?
How would you get the current date in mysql?