On Saturday 28 October 2006 05:34, Ow Mun Heng wrote: > 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)
That's a guesstimate if using InnoDB. Works for MyISAM... -- George-Cristian Bîrzan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]