to add new columns in databases alter table <table name> add co

How can we change the name and data type of a column of a
table?

Question Posted / aftab alam

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

Please Help Members By Posting Answers For Below Questions

What is difference between group by and order by clause?

962

Explain timestamp?

968

What is difference between oracle sql and mysql?

1016

Is mysql good for large database?

925

What is the default port number of mysql?

949

Is sqlite faster than mysql?

943

How to get current MySQL version?

1085

Is sql similar to mysql?

884

How can I see mysql database?

902

How many TRIGGERS are allowed in MySql table?

1081

How do I quit mysql?

934

How to connect html form to mysql database using php?

944

Can varchar be primary key?

921

How to convert character strings to dates?

1083

How we can create index in mysql?

978