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 do I view mysql logs?

491

How can you handle the –secure-file-priv in mysql?

510

What is 1nf 2nf 3nf?

508

What is mysql_pconnect?

470

How do I stop a mysql command?

487

What is a tinyint in mysql?

491

How do I run mysql on a mac?

480

What is 'mysqld'?

510

How do I show users in mysql?

517

What ascii 31?

523

What is horizontally scalable?

511

How many threads can mysql handle?

504

Why mysql is so popular?

516

How to create trigger in mysql workbench?

551

Is mysql distributed?

497