How to access request tab in PhpMyAdmin?

Question

I added a MySQL query to MySQL in phpMyAdmin. How do I access it? I looked at PhpMyAdmin but could not find it.

Answer 1

To run a query with a bookmark, select the database to which your query is being executed (usually in the left column in phpMyAdmin). Then go to “SQL” at the top of the screen. You should then see the section on the Embeddable SQL Query page using the drop-down list for any bookmarked SQL queries.

I ran into a problem that phpMyAdmin seems to duplicate my requested SQL queries when I edit them, and then old and new queries are stored with the same bookmark name. To find out what an SQL query is, you need to do the following:

• Browse the bookmark list source in the drop-down SQL. The identifiers of each bookmark are stored in HTML, for example:

<option value="123">Bookmark_name_1</option> <option value="72">Bookmark_name_2</option> 

• In phpMyAdmin, go to "SQL" and paste the following SQL query:

 SELECT id, label, CONVERT( query USING utf8 ) as query FROM pma_bookmark WHERE id IN ( 72, 123 ); 

• When you click "Go", you will see the requests in plain text.

• Then you can go to the pma_bookmark table in the phpmyadmin database and delete the query with an identifier that you don't need.

Answer 2

My phpMyAdmin version is 4.5.2, and I have to be new to allow adding images to the message, so I will try to describe how best to go to saved posts. On the main page after logging in Click on one of the database names in the left column. When a view of the database structure appears, there is a small icon in the lower left corner of this view. You may need to scroll down to see it, and it looks like a small command line window with the word “Console” next to it. Click on it, and if it is too narrow to see anything, you can drag it up to enlarge it. you can only see the title bar with interactive tabs by clicking on the bookmark, and if you saved the bookmarks, they will be visible in the box below. Then, when your mouse passes over sqls embedded, a panel appears on the sql or query with the words "Expand", "Requery", "Edit" and "Delete".

Hope this works

Answer 3

You can try using the SQL history function, for example: