How can we change the name and data type of a column of a
table?
Answer Posted / aftab alam
to add new columns in databases
alter table <table name> add column <column name> datatype;
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I update a variable in mysql?
What is action query?
Is oracle mysql free?
What is mysql aggregate functions? Explain
What are the ways in which you can retrieve data in the result set of mysql using php?
What is new mysqli?
What are the 3 main types of search queries?
How do you know if your mysql server is alive?
Is mysql a server?
What does mysql flush hosts do?
How do I start mysql client?
What is cast in mysql?
If we use sum function in mysql, does it return sum of that row or for that column?
How to rename an existing column in a table?
How can I compare two mysql databases?