what is mysql ALTER used for code example

Example 1: mysql add column

ALTER TABLE table_name
ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];

Example 2: alert table name mysql

ALTER TABLE exampletable RENAME TO new_table_name;