What is the ALTER command in MySQL

Question

Hi!!

Can someone tell me what exactly is the ALTER command in MySQL?

Answer 1

ALTER

The ALTER command is used to add, modify or delete constraints or columns.

The ‘ALTER TABLE’ Statement

This statement is used to either add, modify or delete constraints and columns from a table.

Syntax:

ALTER TABLE table_name
ADD column_name datatype;