RE: Newbie: Using SELECT to Get Table Status?

2004-12-28 Thread Robinson, Eric
great day. -- Eric Robinson -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 28, 2004 12:22 AM To: mysql@lists.mysql.com Subject: Re: Newbie: Using SELECT to Get Table Status? Hello. You may use count(*) for counting rows. "Robinson, Eric&quo

Re: Newbie: Using SELECT to Get Table Status?

2004-12-28 Thread Gleb Paharenko
Hello. You may use count(*) for counting rows. "Robinson, Eric" <[EMAIL PROTECTED]> wrote: > The mysql>SHOW TABLE STATUS command returns such things as the number or > rows and time of the last update.=20 > > Is it possible to get the same information using a SELECT statement? > > F

Newbie: Using SELECT to Get Table Status?

2004-12-27 Thread Robinson, Eric
The mysql>SHOW TABLE STATUS command returns such things as the number or rows and time of the last update. Is it possible to get the same information using a SELECT statement? FYI, I am writing a script to monitor replication status by comparing this information between the master and slave serv