SQLzoo.net

Error 1146 Table 'gisq.Bbc' doesn't exist

MySQL

Problem

An attempt was made to read from a table that does not exist.

Most likely the table name has been spelt incorrectly.

Possibly the table is not in the current schema or database.

Solutions

  • Correct the spelling of the table name.


Specific to MySQL
In MySQL on LINUX the table names are case sensitive. This means that the table bbc exists but Bbc gives an error. This is a deviation from the SQL standard.