In a table List page I am trying to write a Query (msqli compatible) that checks to see if a table name exists in my database..... JUST THAT.
If the table name (named dynamically using today's date as part of the tablename) exists at all then I want If/Else options depending on whether this is True or False.
If the table does not exist then the script will Create that Table. If tablename "records_06_05_2014" does not yet exist it will be created next.
But I cannot find a query that is not looking for at least one row of data, one record already existing.
The table always starts life Empty, no rows, and I don't want to create a "fake" row that I later have to delete.
I cannot find a Query JUST for discovering if the Table Name itself is in the database and does not care if it has any rows of data to produce a True or False option for the next steps of my script.
Such queries as "SHOW TABLE LIKE " are useless.
I can't find a specific query in my Google and Overstack searches that answers this type of query for the table name itself, even if it has no data yet.
Thank you for advice!