:: DEVELOPER ZONE
MySQL Reference Manual :: A.2.15 Table 'tbl_name' doesn't exist
Search the MySQL manual:
- A.2 Common Errors When Using MySQL Programs
- A.2.1 Access denied
- A.2.2 Can't connect to [local] MySQL server
- A.2.3 Client does not support authentication protocol
- A.2.4 Password Fails When Entered Interactively
- A.2.5 Host 'host_name' is blocked
- A.2.6 Too many connections
- A.2.7 Out of memory
- A.2.8 MySQL server has gone away
- A.2.9 Packet too large
- A.2.10 Communication Errors and Aborted Connections
- A.2.11 The table is full
- A.2.12 Can't create/write to file
- A.2.13 Commands out of sync
- A.2.14 Ignoring user
- A.2.15 Table 'tbl_name' doesn't exist
- A.2.16 Can't initialize character set
- A.2.17 File Not Found
Additional languages
Additional formats
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. See Section 13.5.4, “SHOW Syntax”.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.