October 23rd, 2013, 07:42 PM
Table doesn't exist, but it shows in show tables!
Why can't I select from behnam.shak_content table?
This error is nonesense.
mysql> show tables;
| Tables_in_behnam |
| behnam.shak_content |
| members |
2 rows in set (0.00 sec)
mysql> select * from behnam.shak_content;
ERROR 1146 (42S02): Table 'behnam.shak_content' doesn't exist
October 23rd, 2013, 07:48 PM
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,
then rename the table.
SELECT * FROM `behnam.shak_content`;
October 24th, 2013, 05:43 AM
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.
Originally Posted by requinix
Comments on this post
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
October 25th, 2013, 01:44 AM
Cant rename or drop it either
October 25th, 2013, 02:26 AM
Did you use the backticks in the name reference? Remember that you need those when there's something "wrong" with the table name.
I've just tested that and it works here. I can't imagine why it wouldn't work for you as well - unless you're getting some other error that's not related to the table name.
DROP TABLE `behnam.shak_content`;
October 25th, 2013, 09:42 PM
Yes it's functioning well. I was not using `. I was using '.
Originally Posted by Catacaustic
1 billion things to learn :Q