Bug #51388 Keep query history between sessions

Submitted:	22 Feb 2010 13:27	Modified:	9 Sep 2011 11:42
Reporter:	Alex Whitman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.2.16	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	history, query, SQL

Description:
Currently query history is lost when closing MySQL Workbench.  It would be very useful to be able to keep the history between sessions.

How to repeat:
- Run MySQL Workbench
- Connect to a database
- Run a query
- Query can be found in history tab
- Close MySQL Workbench
- Re-open MySQL Workbench
- Connect to same server
- Nothing available in history tab

Suggested fix:
Store query history on disk between sessions.  History should be grouped by days/weeks like the history used to in MySQL Query Browser.  It would also be useful for history to be stored on a per database connection basis.

Thank you for the feature request.

This has now been documented. This change affects 5.2.35+

+        The query history is now saved between Workbench sessions.

I've been testing the 5.2.35 pre-release binaries and while the history is available, the Date and Time columns are not sortable and have the earliest Date and Time at the top.  To get to a recent entry in the history I have to scroll to the bottom of the list (I've got history entries from over a year ago).

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.