Sunday, December 4, 2011

SQLYOG | Wrong results are returned for FOUND_ROWS().


I am getting wrong results are returned for FOUND_ROWS(). I found easy fix from sqlyog forum.. they have given some steps to fix this problem..

"The problem with FOUND_ROWS() is that it is conflicting with the Query Profiler as Profiler will SELECT .. FROM INFORMATION_SCHEMA ... To use FOUND_ROWS() you will have to turn Query Profiler OFF. If you don't FOUND_ROWS() will return a rowcount for the ´profiling´ table in Information_Schema and not a rowcount for the table where user executed his query. We are considering how we could at least warn about this, of course."

I have attached screent shot where to change to fix this issue...

No comments:

Post a Comment