: 5.0.51a
- PHP extension: mysql
I assume all is well so I copy my Wordpress files to my new web directory,
like I've done in the past, and add the database connection info to its
config.php file. When I view the database in the left column it doesn't show
any table info. In fact it do
t specific table, you can just do:
SHOW TABLE STATUS LIKE 'table_name';
>
>
>
>>From: Victoria Reznichenko <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Re: table info
>>Date: Mon, 19 Jan 2004 14:10:37 +0200
>>
>>"
;\G
cheers,
Tobias
>
>
>
>
> >From: Victoria Reznichenko <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: table info
> >Date: Mon, 19 Jan 2004 14:10:37 +0200
> >
> >"Mike Mapsnac" <[EMAIL PROTECTED]> wrote:
> &g
> I think that main disadvantage of this command is thah it works for the
> database but not for specific table. So if a database has 200 tables, find
> result for specific table is not an easy task.
Easy:
SHOW TABLE STATUS LIKE 'table_name'
Regards, Jigal.
--
MySQL General Mailing List
For l
I think that main disadvantage of this command is thah it works for the
database but not for specific table. So if a database has 200 tables, find
result for specific table is not an easy task.
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: table inf
"Mike Mapsnac" <[EMAIL PROTECTED]> wrote:
> Is it possible to find out when the table was created? How to get information about
> the table?
SHOW TABLE STATUS command provides info about table:
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
--
For technical support contracts, goto
On Sat, 17 Jan 2004, Mike Mapsnac wrote:
> Is it possible to find out when the table was created? How to get information about
> the table?
>
You can use the unix command `stat`, the last of the 4 dates will be the
creation date (in the order of Last Accessed, Last Modified, Last Inode
modificat
Is it possible to find out when the table was created? How to get information about
the table?
Thanks
