Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115347 views)
- Error no. 2003: Can't connect... (52073 views)
- Error no. 1251: "Client does not support authentication..." (48079 views)
- Error no. 1045: "Connection denied..." (41320 views)
- SQLyog Version History (39926 views)
- What is HTTP-tunneling? (29273 views)
- Error No. 2005: Unknown MySQL server host... (28329 views)
- What Is SSH and SSH-tunneling? (25479 views)
- Why are Stored Procedures not created when I import ... (23444 views)
- Do I need PHP to use SQLyog with MySQL? ... (21508 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
Using the GUI
Wrong results are returned for FOUND_ROWS().
FOUND_ROWS() is an 'information function' in MySQL. The use of it is that you can use a LIMIT clause to reduce the result set and also retrieve a rowcount for the table from the same query like "SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name LIMIT"
It is described in MySQL manual here:
http://dev.mysql.com/doc/refman/5.1/en/information-functions.html
Notice in particular this: "In the absence of the SQL_CALC_FOUND_ROWS option in the most recent successful SELECT statement, FOUND_ROWS() returns the number of rows in the result set returned by that statement."
That can be a problem with GUI tools because they may execute SELECT statements (mostly SELECT .. FROM INFORMATION_SCHEMA ..) in order provide user with information in the GUI. SQLyog will mostly use SHOW statements, but there are places where we SELECT .. FROM INFORMATION_SCHEMA .. because it is most efficient or because it is the only option.
SELECT .. FROM INFORMATION_SCHEMA .. is used
1) Sometimes when populating Object Browser details for 'stored programs'
2) For getting profiling information for the Query Profiler feature. It is not feasible unfortunately to use a SHOW statement instead of SELECT .. FROM INFORMATION_SCHEMA .. The SHOW PROFILES statement may return a much too large dataset to be handled efficiently (as there is no option to use a LIKE-clause or a WHERE-clause with SHOW PROFILES).
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.
Tags: -
Related entries:
- SQLyog Version History
- Error no. 1045: "Connection denied..."
- Plans for future versions of SQLyog
- MySQL 5 objects are greyed out in "copy DB to other host" dialogue.
- Can I use SQLyog with MySQL version 5 features like Views, Stored Procedures and Triggers
Last update: 2009-08-12 06:31
Author: Peter Laursen
Revision: 1.1
You can comment this FAQ