MySQL: Table ‘SOME_TABLE’ doesn’t exist whereas it does exist

15 Jul

In recent development, I tried to connect MySQL database locally in my C# application, and it worked fine. But when I created the same database and tables using sql script in Ubuntu, and using the same application to connect the mysql database, below error/exception occurred:

Table ‘SOME_TABLE’ doesn’t exist

Logging into MySQL and I found the table does exist:

use mydb;
show tables;

Ultimately, it turns out it is the case–sensitive problem: in windows, this is not a problem, but in Ubuntu it is!

After changing the table name to right case (e.g. table name –> TABLE NAME), it worked fine!

Leave a comment

Posted by on July 15, 2015 in Programming


Tags: , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: