Re: counting rows in all tables

2004-03-25 Thread Don Read
On 25-Mar-2004 [EMAIL PROTECTED] wrote: > Not using perl or php I came up with: > > mysqlshow -u user --status db_name | awk -F"|" '{print $2,$5}' | grep > -i pattern > > Is there a query to do the same thing? > > SHOW TABLE STATUS -- Don Read [EMAIL PRO

counting rows in all tables

2004-03-24 Thread doug
Not using perl or php I came up with: mysqlshow -u user --status db_name | awk -F"|" '{print $2,$5}' | grep -i pattern Is there a query to do the same thing? _ Douglas Denault [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 -- MySQL General Mailing List For list archives: http:/