Hi, just wondering if there a quick way to determine the # of rows in a mysql table.
I know I can do a count(*) but that would entail a table scan etc. I found out that I can do the query into the information_schema table, however, I don't get a consistent reading. executing it multiple times, I get multiple numbers. (and no, the table is static already, no updates/deletes etc) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
