Jean Zhong wrote:

mysql> show table status from jean1;

It gave me the following error:

ERROR 12: Can't read dir of './jean1/' (Errcode: 2)

In "SHOW TABLE STATUS", the thing after the "FROM" is a database name. See here:

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]



Reply via email to