Check if MySQL table exists without using “select from” syntax?

Is there a way to check if a table exists without selecting and checking values from it?

That is, I know I can go SELECT testcol FROM testtable and check the count of fields returned, but it seems there must be a more direct / elegant way to do it.

19 Answers
19

Leave a Comment