: 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 doesn't show
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
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 info
Date
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
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:
Is it possible to find out when the table was created? How to get
information about the table?
SHOW TABLE STATUS
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
Mike Mapsnac [EMAIL PROTECTED] wrote:
Is it possible to find out when the table was created? How to get
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
Is it possible to find out when the table was created? How to get information about
the table?
Thanks