Menu

#163 Remember SQL query after editing a row.

3.2.2
closed-wont-fix
MySQL (74)
5
2011-06-24
2011-06-24
Xtina
No

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

Steps:

* 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.

Result:

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.

Discussion

  • 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.