On Sat, 2006-10-28 at 05:44 +0300, George-Cristian Bîrzan wrote: > 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...
I'm using InnoDB, Thanks for the info then. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
