Yes it is possible to do the requested checks and creation but this means the users has to have create privileges.

My question is why is it that you are having to do this? Dropping and recreating tables has a lot more issues than just truncating the data in the table.

If you are just creating temporary tables for doing data processing that get removed later it is sometimes a good idea to create these on start up of the database.

Oracle, SQL Server and Sybase have methods of doing this but with mySQL it is usually better to add a simple connect and create script to the end of the daemon start up with a drop before the shutdown.

Hope this helps
UnderMine