Table name rotation

[jingsm]

I have several questions as blow. please check it out.

Q1. can I rotate table name by each day? I'd like to use the variables which was dedicated table name by each day. i.e.) table logtable => table logtable_{yyyyMMdd}, logtable_20160220, logtable_20160221 ... If not, would you suggest better ideas?

Q2. can I create DB table when necessary or check to exist the table? i.e) create table when is not existed the table.

Thank you.