Скачать или смотреть Resolving phpMyAdmin Automatic Query Issues: How to Restore Default Table Browsing Behavior

Discover how to fix the automatic query issue in phpMyAdmin that changes the default browsing behavior when accessing tables. Follow our step-by-step guide to restore the standard functionality.
---
This video is based on the question https://stackoverflow.com/q/64054112/ asked by the user 'J.R.' ( https://stackoverflow.com/u/2037698/ ) and on the answer https://stackoverflow.com/a/64054335/ provided by the user 'Ajinkya Bawaskar' ( https://stackoverflow.com/u/7339417/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: phpMyAdmin automatically running odd query when clicking browse table

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Introduction

If you're using phpMyAdmin, you might have encountered an annoying issue where clicking the "BROWSE" button for a table runs an unexpected query. Instead of the standard SELECT * FROM table_name, phpMyAdmin runs a query like SELECT * FROM table_nameORDER BYcolumn_name ASC LIMIT 0, 25. This can be frustrating, especially if you rely on the default behavior for quick table access.

In this guide, we'll walk you through how to resolve this issue and restore the default browsing behavior in phpMyAdmin.

Understanding the Problem

When you click on "BROWSE," the expected query is a simple SELECT * FROM table_name. However, in certain cases, you may find that phpMyAdmin remembers custom sorting or filtering settings for your tables, leading to the automatic generation of unexpected queries.

This problem can arise due to:

Prior custom settings in your phpMyAdmin configuration.

Changes to the table structure or indexes.

User-specific settings that have been saved.

The Solution

To tackle this problem, follow these step-by-step instructions:

Step 1: Access the Settings

Navigate through the phpMyAdmin interface:

Start by logging into your phpMyAdmin panel.

On the main menu, look for the Server tab.

Click on Settings from the dropdown.

Step 2: Change Browse Mode

Locate Browse Settings:

In the Main Panel, find the Browse Mode settings.

Here, you will see options related to default sorting order.

Adjust Default Sorting Order:

Change the sorting order to SMART.

SMART means descending order for columns of type TIME, DATE, DATETIME, and TIMESTAMP. Depending on other column types, it will sort accordingly (usually ascending).

Step 3: Uncheck Remembered Sorting

Disable Remembered Sorting:

Look for the option labeled "Remember table's sorting" on the same page.

Uncheck this box to prevent phpMyAdmin from storing any future sorting preferences that could lead to the same issue.

Conclusion

By following these steps, you should be able to revert phpMyAdmin to its default querying behavior when you browse tables. This adjustment not only resolves the automatic sorting queries but also enhances your overall efficiency when managing databases through phpMyAdmin.

If you encounter any further issues, remember to consult the phpMyAdmin documentation or community forums. Staying in the loop with the latest updates can also help you avoid such hiccups in the future.

Feel free to share your experiences or any additional solutions you might have in the comments below!