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? > > FYI, I am writing a script to monitor replication status by comparing > this information between the master and slave servers. > > -- > Eric Robinson > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
