Remember SQL query after editing a row.
Database management in a single PHP file
Brought to you by:
jakubvrana
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.
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.