Jean Zhong wrote:
In "SHOW TABLE STATUS", the thing after the "FROM" is a database name. See here:mysql> show table status from jean1;
It gave me the following error:
ERROR 12: Can't read dir of './jean1/' (Errcode: 2)
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
You want
SHOW TABLE STATUS FROM jeandatabase;
or maybe
SHOW TABLE STATUS LIKE 'jean';
-- Keith Ivey <[EMAIL PROTECTED]> Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]