title: Check if table exists in mysql
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/8829102/mysql-check-if-table-exists-without-using-select-from">MySQL - check if table exists without using “select from”</a>  </p>
  </blockquote>
  
  
  
  <p>Can I rely on this query to find out if tables in the specified database exists or there may be some restrictions?</p>
  
  <pre><code>SELECT
      `information_schema`.`TABLES`.`TABLE_NAME`
  FROM
      `information_schema`.`TABLES`
  WHERE
      `information_schema`.`TABLES`.`TABLE_SCHEMA` = 'my_database_name'
  AND `information_schema`.`TABLES`.`TABLE_NAME` IN (
      'table_name',
      'table_name',
      'table_name',
      'table_name',
      'table_name',
      'table_name'
  )
  </code></pre>
  
  <p>P.S.
  I do not need to create a table, and just need to check whether it exists or not.</p>