Hello,
Thank you very much, everyone.
Yes, I want to know the table "jean1" status.
I tried:
show table status like "jean1"
It works.
Thanks a lot.
Jean
--- mos <[EMAIL PROTECTED]> wrote:
> Jean,
> The "from jean1" is looking for a database
> named "jean1", it is
> not the table n
Jean,
The "from jean1" is looking for a database named "jean1", it is
not the table name. See
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
If you are already connected to the database, just use:
Show Table Status;
If you want status for a particular table then try:
Sh
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 TAB
Jean,
Here is the format for the SHOW TABLE STATUS command from
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html:
SHOW TABLE STATUS [FROM db_name] [LIKE wild]
You are using FROM not your database's name. Try this:
SHOW TABLE STATUS FROM jeandatabase
and see if it works better ;)
Respe
