SQL_CALC_FOUND_ROWS when filtering in data tab

[expired user #8405]'s profile image [expired user #8405] posted 9 years ago in Feature discussion Permalink
Hello,

when i use a filter (where clause) in the data tab, i don't see all the row counts affected to the filter. Only the totally rows in the table are shown.

Is there a chance to implement a SQL_CALC_FOUND_ROWS in the data tab?

Martin
jfalch's profile image jfalch posted 9 years ago Permalink
workaround: whenever a filter is applied, a corresponding sql query is written to the log pane (bottom). Copy it to a query window (using log panes' context menu), execute, then you'ĺl get the "affected rows / found row" comment that says how many rows have been found by the filter.

IMHO, it should however not be too difficult to implement this comment being written automatically for internally generated "SELECT" type queries as well, since it only displays counters readily available from mysql after any SELECT...

Please login to leave a reply, or register at first.