Check if MySQL table exists or not

Question

Possible Duplicate    MySQL check if a table exists without throwing an exception       I have a dynamic mysql query builder in my project that creates select queries from different tables  I need to check if the current processing table exists or not  Imagine that my tables are table1  table2  and table3  My code is something like this      lt  php for  i   1    i  lt   3    i          this table    table   i      query   mysql query  SELECT   FROM  this table                  gt    How can I do this check  Please tell me the simplest way

User · Answer

You can try this   query   mysql query  SELECT   FROM  this table   or die  mysql error       or this   query   mysql query  SELECT   FROM  this table   or die   Table does not exists       or this   query   mysql query  SELECT   FROM  this table     if   query     echo  The    this table   does not exists     Hope it helps

User · Answer

Taken from another post   checktable   mysql query  SHOW TABLES LIKE   this table      table exists   mysql num rows  checktable   gt  0

User · Answer

query   mysqli query  SELECT TABLE NAME FROM information schema TABLES WHERE TABLE NAME IN   table1   table2   table3   AND TABLE SCHEMA  yourschema      tablesExists   array    while  null     row mysqli fetch row  query           tablesExists      row 0

User · Answer

MySQL way   SHOW TABLES LIKE  pattern    There s also a deprecated PHP function for listing all db tables  take a look at http   php net manual en function mysql-list-tables php  Checkout that link  there are plenty of useful insight on the comments over there

User · Answer

result   mysql query  SHOW TABLES FROM  dbname     while  row   mysql fetch row  result           arr      row 0      if in array  table  arr       echo  Table exists

User · Answer

Updated mysqli version   if   result    mysqli- gt query  SHOW TABLES LIKE     table             if  result- gt num rows    1            echo  Table exists           else       echo  Table does not exist       Original mysql version   if mysql num rows mysql query  SHOW TABLES LIKE     table        1       echo  Table exists   else echo  Table does not exist     Referenced from the PHP docs

User · Answer

Use this query and then check the results    query    show tables like  test1

[php] Check if MySQL table exists or not

Examples related to php

Examples related to mysql

Examples related to exists