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)
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;
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.
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.