#163 Remember SQL query after editing a row.

MySQL (68)

I have a simple table, `books`, that has three fields: id, name, rating.


* Log in, select a database, and click SQL command.
* Execute this query: select * from books where rating = 0;
* Click the ID of any row to edit it.
* Change the rating to 3, and click Save.


The row is edited just fine, but the results page shows all results from table `books`, not just those where the rating is 0.

Change request:

I'd like it if the SQL query I first ran is remembered, and reran when I click Save. Run these steps in phpMyAdmin; you'll see what I mean there.

If not then not, I just figured I'd ask.


  • Jakub Vrána

    Jakub Vrána - 2011-06-24

    There's no need to run universal SQL command for this in Adminer. You can achieve the same behavior in simple select from the table. This behavior is supported in the simple select.

    The problem with SQL command is that it can have side-effects so returning to it would cause these side-effects again.

  • Jakub Vrána

    Jakub Vrána - 2011-06-24
    • status: open --> closed-wont-fix

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks