ALTER
is a DDL (Data Definition Language) statement. Whereas UPDATE
is a DML (Data Manipulation Language) statement. ALTER
is used to update the structure of the table (add/remove field/index etc). Whereas UPDATE
is used to update data.
ALTER
is a DDL (Data Definition Language) statement. Whereas UPDATE
is a DML (Data Manipulation Language) statement. ALTER
is used to update the structure of the table (add/remove field/index etc). Whereas UPDATE
is used to update data.