MariaDB预处理语句无语法错误但未返回数据，原因何在？

Let's break down why your prepared statement runs without syntax errors but returns no data—here are the most likely things you missed:

• You haven't switched to the correct database
  If your pages table lives in a specific database (say, test_db), but your current MariaDB session is still using the default mysql database (or another unrelated one), your prepared statement is looking for pages in the wrong place. Since MariaDB won't throw an error if a table with that name exists in the current database (even if it's empty), you'll get an empty result set.
  Fix this either by switching databases first:

  USE your_target_database;
  PREPARE stmt from 'SELECT * FROM `pages`;';
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
  

  Or explicitly specify the database in your query:

  PREPARE stmt from 'SELECT * FROM `your_target_database`.`pages`;';
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
  

• Your current session has uncommitted transactions hiding data
  If you previously ran a DELETE or UPDATE on pages without committing the transaction (and have autocommit disabled), your session will see the modified (empty) version of the table while other sessions might still see the test data. Run COMMIT; or ROLLBACK; to reset the session state before executing your prepared statement.

• Double-check table name case (Linux systems only)
  MariaDB on Linux is case-sensitive for table names by default. If your actual table is named Pages (with a capital P) but you're querying pages in backticks, you might be targeting a different (possibly empty) table. This should usually throw a "table not found" error—but if you accidentally created an empty pages table alongside the correct Pages one, you'd get an empty result. Verify exact table names with SHOW TABLES;.

One quick sanity check: Run SELECT * FROM pages; directly (no prepared statement). If that also returns no rows, the issue isn't with the prepared statement itself—it's with your session context or the table's data state.

内容的提问来源于stack exchange，提问作者Matthi