Question

What is the purpose of ALTER TABLE command in MySQL? How is it different from UPDATE command?

Answer 1

Alter table changes the structure of table in database. It is used to change/add a column defination.

But update command only updates the data row in the table as per the conditions specified in where clause.