I am having multiple tables with same structure and a template table which is the master for all of these tables.
Is there a way that whenever i make any changes to master table(in structure), The child tables should get updated to always keep the structure same as of the master template table.
I am using php and mysql for this operation.
For startup i am using queries like
SHOW TABLE STATUS FROM 'test%'
and then i want help for comparing table columns
and then if a column is missing in child table then i can create that column.