In this article I will explain with an example, how to resolve the following error: Table doesn�t exist while working with MySQL database.
 
 

Error

This error occurs due to the following reasons in MySQL database.
1. MySQL query is being executed with wrong table name.
2. MySQL query is being executed without providing column. (i.e.SELECT FROM Customers)
MySqlException: 'Table doesn't exist' error in MySql Database
 
 

Example:

Wrong Table Name: Correct name is Customers.
SELECT * FROM Customer;
 

Without providing Column Name

SELECT FROM Customers;
 
 

Solution

Following is the solution for the above error.
1. Make sure that the table name is correct and column name is also provided as shown below.
SELECT CustomerId, Name, Country FROM Customers;