Discuss Table doesn't exist, but it shows in show tables! in the MySQL Help forum on Dev Shed. Table doesn't exist, but it shows in show tables! MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
Time spent in forums: 1 Month 1 Week 2 Days 21 h 37 m 10 sec
Reputation Power: 1585
Originally Posted by requinix
Somehow you managed to name a table with a period in it. That's bad.
If you just say "behnam.shak_content" MySQL will think you mean the shak_content table in the behnam database.
First use quotes,
SELECT * FROM `behnam.shak_content`;
then rename the table.
How much you want to bet that is how the create table was done (with `behnam.shak_content` instead of `behnam`.`shak_content`)? - even if the backticks are not needed.
The moon on the one hand, the dawn on the other:
The moon is my sister, the dawn is my brother.
The moon on my left and the dawn on my right.
My brother, good morning: my sister, good night.
-- Hilaire Belloc