homepage Welcome to WebmasterWorld Guest from 54.161.247.22
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Mysql "rows in set" result lower than actual
ianevans




msg:4000800
 9:55 am on Oct 4, 2009 (gmt 0)

[never mind...was basing this on the auto_increment photo id number and didn't take into account the fact that we had deleted some over the years. Just getting a washcloth to take the egg off my face. :-) ]

While working on a database of photos that has just climbed to 10,018 entries, I looked at the table in both phpmyadmin and via command line and noticed that the result for a select * from photos said:

9990 rows in set (0.03 sec)

Why would the numbers be off? Is it just a lag in reporting?

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved