allelopath
asked on
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)
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER