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 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: > > Show Table Status like "jean1"; > > or > > Show Table Status like "jean%"; > > if you have more than 1 table starting with "jean". > > Mike > > > At 10:04 AM 6/10/2004, you wrote: > >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 I try to take a look on the table1 status > >by: > > > >mysql> show table status from jean1; > > > >It gave me the following error: > > > >ERROR 12: Can't read dir of './jean1/' (Errcode: 2) > > > >I think it supposes that there would be a > sub-directry > >under .../jeandatabase/, and named jean1. > > > >But when I cd to > /usr/local/mysql/data/jeandatabase/ > > > >There are three files: > >jean1.MYD > >jean1.MYI > >jean1.frm > > > >I wonder if the way I import the table is not > correct. > > > >Could anyone give me some ideas about this problem? > >Thank you very much. > > > >Jean > > > > > > > > > > > > > > > >__________________________________ > >Do you Yahoo!? > >Friends. Fun. Try the all-new Yahoo! Messenger. > >http://messenger.yahoo.com/ > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
