Table tbl_name doesn't exist

The following error indicates that a specified table does not exist in the default database:

Table 'tbl_name' doesn't existCan't find file: 'tbl_name' (errno: 2)

In some cases, the user may be referring to the table incorrectly. It is possible because the MySQL server uses directories and files for storing database tables. Depending upon the operating system file management, the database and table names can be case sensitive.

For non case-sensitive filesystems, such as Windows, the references to a specified table used within a query must use the same letter case.

Get MySQL 8 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.