managing multiple tables with same table structure in mysql

271 views Asked by At

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.

0

There are 0 answers