mysql add a column to a number of tables
From this question, I understand that, you need to store same data multiple times on a database. Before starting this understand that, it is not necessary to store same data multiple times on database. IF I understood correct, a simple work around will be, have a master table group with data guppy, barb, goldfishand use its primary id on a child tables.
Example:

master table:

create table group (id int, group_name char(10), id primary key) engine = innodb;


child table:

create table child1 (id int, group_id int, ..... foreign key group_id references group(id), id primary key) engine = innodb;

But, it depends on your requirement, may be after analyzing complete requirement, this model may/may not applicable. I hope this answer will help you in some way. Thank you.