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 the datatype of image?

1004

Explain the difference between primary key and candidate key in mysql?

1010

What is mysql routine?

1021

How many rows mysql can handle?

980

Where is the mysql data directory?

991

How to include comments in sql statements?

1018

Why we use mysql database?

984

How do you name a table?

934

How do I find mysql location?

1009

Why we use mysqli instead of mysql?

1168

What is the difference between is null & is not null?

1044

What do ddl, dml, and dcl stand for?

964

How do I clear a mysql database?

1011

What is sql in mysql?

1086

What is required to create mysql database?

1032