MySql workbench query history ( last executed query / queries ) i.e. create / alter table, select, insert update queries

mysql mysql-workbench history
murtaza.webdev picture murtaza.webdev · Oct 28, 2014 · Viewed 64.4k times · Source

Want to see last executed queries in MySql Workbench whether its

create / alter table query

select / insert / update query or any query list.

in short want to see history of all queries

Answer

Philip Olson picture Philip Olson · Oct 28, 2014

From the bottom panel, change "Action Output" to "History" and then choose the appropriate date.

Alternatively, the SQL statement history is stored in text files under two locations:

  • sql_history/yyyy-mm-dd e.g., sql_history/2015-04-01: Full Workbench SQL history for all MySQL connections
  • log/sql_actions_.log*: SQL history execution results, but without the data, and separated per MySQL connection

The location of these files depends on your system. For additional details, see MySQL Workbench Settings and Log Files

In both cases, you will see the query history.

enter image description here

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More