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
cc:
Fax to:
06/10/2004 11:04 Subject: "show table status" problem
Hello, everyone
I am new on MySQL.
I created several tables by command:
%mysql jeandatabase -u root -h localhost -p <
jean1.sql
and jean1.sql is as follows:
use jeandatabase;
drop table if exists jean1;
create table jean1(
id int not null,
field1 char(9),
primary key(id)
);
But, when
