phpMyAdmin中SQL代码仅显示30行数据？数据库实际数据更多

Hey there! Let's sort out this frustrating issue you and Tom are running into—where your SQL queries only return 30 rows even though your database has way more data. This is a super common problem with easy fixes, so let's break down the likely causes and solutions:

1. phpMyAdmin's Default Row Limit #

By default, phpMyAdmin caps the number of rows displayed per query to keep the interface fast and prevent overwhelming your browser. Here's how to work around it:

• After running your SQL query, look for options at the top or bottom of the results page. You'll see a dropdown (usually set to "30")—change this to a higher number like 100, or select "All" to show every row (note: this might be slow if you have thousands of rows).
• Alternatively, add a LIMIT clause to your query manually if you want specific rows, e.g., SELECT * FROM your_table LIMIT 100 to get the first 100 rows.

2. Accidental LIMIT 30 in Your SQL Code #

Double-check the SQL Tom shared—did someone accidentally add a LIMIT 30 at the end of the query? If so, either remove the LIMIT clause entirely or adjust the number to match how many rows you need (e.g., LIMIT 200). It's an easy oversight, especially if you copied a template query!

3. phpMyAdmin Configuration Settings #

If you want to change the default limit permanently, you can edit phpMyAdmin's config file:

• Locate config.inc.php (usually in your phpMyAdmin installation directory).
• Find the line that says $cfg['MaxRows'] = 30; and change the number to your preferred default (like 100). Setting it to 0 will remove the limit, but be cautious—loading huge datasets can crash your browser or slow down the server.

4. Pagination is Hiding Rows #

phpMyAdmin splits large result sets into pages. After running your query, check the bottom of the results table—you'll see pagination links (like "1, 2, 3...") that let you navigate to the rest of your data. Clicking "Next" or a page number will show the rows you're missing.

Quick Tip for Large Datasets #

If your table has tens of thousands of rows, avoid selecting "All"—use pagination with LIMIT and OFFSET instead to fetch chunks of data without performance hits. For example:

SELECT * FROM your_table LIMIT 30 OFFSET 30; -- Gets rows 31-60

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