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

How can we get the number of rows affected by query?

1067

What is the use of mysqli_fetch_array?

1048

What is mysql and mysqli?

929

How can we optimize stored procedure?

951

How to use case expression?

955

What are the 3 main types of search queries?

839

How do I clear a mysql database?

956

What is cursor in mysql?

897

What are the differences between char and varchar?

1111

How to create a new table in mysql?

1047

What is text?

968

What is procedural api?

997

What is max connection in mysql?

932

What is the purpose of using ifnull() function?

991

How to update a root password.

955