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


Please Help Members By Posting Answers For Below Questions

How do I update a variable in mysql?

699


What is action query?

680


Is oracle mysql free?

669


What is mysql aggregate functions? Explain

776


What are the ways in which you can retrieve data in the result set of mysql using php?

692


What is new mysqli?

704


What are the 3 main types of search queries?

645


How do you know if your mysql server is alive?

739


Is mysql a server?

652


What does mysql flush hosts do?

666


How do I start mysql client?

720


What is cast in mysql?

679


If we use sum function in mysql, does it return sum of that row or for that column?

738


How to rename an existing column in a table?

755


How can I compare two mysql databases?

675