On Thu, 4 Apr 2002, denonymous wrote:
> From: "andy thomas" <[EMAIL PROTECTED]>
>
> > Is there a command I can give in the mysql client to find the number of
> > rows in a table or, better still, the number of rows in all the tables in
> > a database?
>
>
> To return the # of rows in a table:
> SELECT COUNT(*) FROM table_name;
Thanks, this works fine! I keep apache access logs for web servers in
MySQL databases and was wondering why the database for March's logs on
a particular server was about a third of the size of February's even
though the access stats looked about the same for those months. Hence the
need to compare the table sizes.
cheers,
Andy
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
