show table status return empty set

Below, the show table status returns an empty set when I think it shouldn't
Can anyone explain?

mysql> use mydb
Database changed
mysql> show tables;
+---------------------+
| Tables_in_mydb |
+---------------------+
| loans_table         |
+---------------------+
1 row in set (0.03 sec)

mysql> show table status;
Empty set (0.06 sec)

mysql> show table status from mydb;
Empty set (0.00 sec)
LVL 1
allelopathAsked:
Who is Participating?
 
Aleksandar BradarićSoftware DeveloperCommented:
Very strange... Try issuing:
---
CHECK TABLE loans_table;
---

If it reports any errors, then call:
---
OPTIMIZE TABLE loans_table;
---

If CHECK TABLE does not return any erros, could you post here the results of the following queries:
---
EXPLAIN loans_table;
SELECT * FROM loans_table LIMIT 1;
---
0
 
allelopathAuthor Commented:
I was seeing other funny things, so I ended up just deleted everything and starting over (No big deal, still very much in the experimental phase). but thanks for your response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.