how to alter a mysql table 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;