get table count in mysql

Now a days I have work for one application in which I have to create and drop tables dynamically and based on these new tables I have to perform such