On Wed, Jul 02, 2003 at 10:57:18AM -0500, Roy W wrote: > Is there a simple MySQL command that will give a Row Count (# of records) > WITHOUT running a select (huge database)
If it's a MyISAM table, just run a SELECT COUNT(*) FROM table_name. It's really efficient. Try it. :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 31 days, processed 979,861,677 queries (357/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]