StackOverflow Questions for Tag: sql-calc-found-rows

travis wilder
travis wilder

Reputation: 149

MySQL - ORDER BY clause causing SQL_CALC_FOUND_ROWS select to not return data

Score: 1

Views: 193

Answers: 1

Read More

FOUND_ROWS() in MariaDB 10

Score: 0

Views: 911

Answers: 2

Read More
silver_river
silver_river

Reputation: 169

Value return incorrectly after calculated field

Score: 1

Views: 47

Answers: 2

Read More
cosmicsafari
cosmicsafari

Reputation: 4049

How to get the SQL_CALC_FOUND_ROWS value using prepared statements?

Score: 6

Views: 3973

Answers: 2

Read More
Taylor Austin
Taylor Austin

Reputation: 6007

Is SQL_CALC_FOUND_ROWS / select FOUND_ROWS() subject to race conditions?

Score: 1

Views: 511

Answers: 1

Read More
Ryan Griggs
Ryan Griggs

Reputation: 2758

MySQL/MariaDB FOUND_ROWS returns 1 even if no rows were returned

Score: 3

Views: 1509

Answers: 1

Read More
murvinlai
murvinlai

Reputation: 50375

How to use MySQL Found_Rows() in PHP?

Score: 24

Views: 51466

Answers: 7

Read More
hu7sy
hu7sy

Reputation: 961

Why FOUND_ROWS() returns wrong result for 5.7.17 SQL version?

Score: 5

Views: 1175

Answers: 1

Read More
MrB
MrB

Reputation: 1594

Java, prepareStatement, SQL_CALC_FOUND_ROWS, FoundRows() hows it work

Score: 1

Views: 1367

Answers: 1

Read More
sai sanath
sai sanath

Reputation: 51

SQL_CALC_FOUND_ROWS with FOUND_ROWS always returns 1

Score: 2

Views: 3233

Answers: 2

Read More
user8645601
user8645601

Reputation: 97

can't understand a code line about powerbuilder 11.5 's SQLCA

Score: 1

Views: 354

Answers: 1

Read More
user982962
user982962

Reputation: 21

Mysql FOUND_ROWS with HAVING statement

Score: 1

Views: 298

Answers: 1

Read More
BenOfTheNorth
BenOfTheNorth

Reputation: 2872

MySQL / PDO FOUND_ROWS() sometimes falsely returning 0

Score: 10

Views: 1163

Answers: 4

Read More
Sylvain Martens
Sylvain Martens

Reputation: 1436

MySqlDataReader doesnt read my query as if there was no rows returned but PHPMyAdmin return rows with the same query

Score: 1

Views: 152

Answers: 1

Read More
Archish
Archish

Reputation: 870

Issues using function FOUND_ROWS() giving wrong result with join

Score: 0

Views: 346

Answers: 1

Read More
mulllhausen
mulllhausen

Reputation: 4435

MySQL stops using index when SQL_CALC_FOUND_ROWS is added

Score: 1

Views: 633

Answers: 0

Read More
yodann
yodann

Reputation: 355

SQL_CALC_FOUND_ROWS on UNION to get total row but with LIMIT on sub query

Score: 1

Views: 1353

Answers: 3

Read More
Nyxynyx
Nyxynyx

Reputation: 63687

Wrong result with FOUND_ROWS() in mySQL

Score: 3

Views: 4499

Answers: 3

Read More
Mathieu
Mathieu

Reputation: 4787

Use of FOUND_ROWS in login page

Score: 0

Views: 156

Answers: 1

Read More
Edward Tanguay
Edward Tanguay

Reputation: 193352

How to avoid error "Incorrect usage/placement of SQL_CALC_FOUND_ROWS"?

Score: 0

Views: 2243

Answers: 1

Read More
PreviousPage 1Next