mysql add new column to select query code example
Example 1: create column mysql terminal
alter table icecream add column flavor varchar (20) ;
Example 2: mysql alter table add column
ALTER TABLE table
ADD [COLUMN] column_name column_definition
[FIRST|AFTER existing_column];