I have used limit and offset in the past for pagination, but now I am getting a HY000 error when trying to run it. Removing "LIMIT 30" returns all 10,000 rows with no problem. Using PDO (pdo_mysql v. 5.5.50), and PHP 5.5.9.
PHP
$stmt = $this->con->prepare("SELECT * FROM taxon LIMIT 30");
if(!$stmt->execute()){
print_r($stmt->errorInfo());
}
Result:
Array
(
[0] => HY000
[1] => 102
[2] => General SQL Server error: Check messages from the SQL Server [102] (severity 15) [(null)]
[3] => -1
[4] => 15
)
EDIT: My issue was that after moving to MYSQL recently, I was still pointing to my old MSSQL database. Solved.