PHPMyAdmin - How to Save Queries

Question

Is there a way to get PHPMyAdmin to save the queries that you enter manually through the SQL tab? I don't want it to save every single query it runs for obvious reasons, I just want to be able to save the ones I enter in there, cuz some of them are very useful, and sometimes I forget how I did it afterwards.

Answer 1

Sure, once you configure the "phpMyAdmin configuration storage" features, you can use the bookmarked query feature to save and recall arbitrary SQL queries.

Here you can see the standard SQL query window; above the Delimiter area you can see the place to give a query a name and create a bookmark (simply enter a name here and run the query; this saves it automatically).

Under the "Bookmarked SQL query" region, you can see the dropdown to select an existing bookmark (here I've selected the "bookmark demo" and selected to "view only" rather than actually executing the query. I find this feature quite handy.

You may also be interested in the History feature, which is available through the "Console" text at the very bottom of the screen.