in reply to DBI: Better way to find number of rows in a table?

You can do this in one query in MySQL since version 3.23 - try

SHOW TABLE STATUS

It also supports LIKE 'MYTABLE%' wildcards.

Regards

Jeff

  • Comment on Re: DBI: Better way to find number of rows in a table?

In Section Seekers of Perl Wisdom