DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Cannot find table

Info Catalog (mysql.info.gz) Ignoring user (mysql.info.gz) Common errors (mysql.info.gz) Cannot initialize character set
 
 A.2.15 `Table 'TBL_NAME' doesn't exist'
 ---------------------------------------
 
 If you get either of the following errors, it usually means that no
 table exists in the current database with the given name:
 
      Table 'TBL_NAME' doesn't exist
      Can't find file: 'TBL_NAME' (errno: 2)
 
 In some cases, it may be that the table does exist but that you are
 referring to it incorrectly:
 
    * Because MySQL uses directories and files to store databases and
      tables, database and table names are case sensitive if they are
      located on a filesystem that has case-sensitive filenames.
 
    * Even for filesystems that are not case sensitive, such as on
      Windows, all references to a given table within a query must use
      the same lettercase.
 
 
 You can check which tables are in the current database with `SHOW
 TABLES'.  `SHOW' SHOW.
 
Info Catalog (mysql.info.gz) Ignoring user (mysql.info.gz) Common errors (mysql.info.gz) Cannot initialize character set
automatically generated byinfo2html