creating tables dynamically in MySql from existing table
===

am creating a website and linking it to mysql database by php
I have one major table that the user of the website can enter values in and I want to create tables from that big table dynamically 

for example, I have a table that has some records of schools visits, a school might appear more than once in the records so I want to have tables for each school independently which takes its  information from the big table and update its values whenever a new record is entered for that school. Am not sure if this can be done dynamically am kind of new to MySql,, any ideas?

Thank you