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 are the advantages of mysql?

529

What is the limit of mysql database?

485

Explain % and _ inside like statement?

577

Explain the difference between mysql and mysql interfaces in php?

542

What is clob datatype?

474

Is blocked because of many connection errors mysql?

431

What is the current root password of mysql?

480

How many rows can mysql hold?

463

What is dump in mysql?

463

Is mysql better than oracle?

465

How to get a list of all tables in a database?

570

How do I truncate all tables in mysql?

478

What is prepare statement in mysql?

497

How to dump one database for backup.

484

What is difference between mysqli and pdo?

467