Menu
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
419
Run the following command: mysql> SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ') FROM information_schema. processlist WHERE user <> 'system user'; This will kill all your MySQL queries.
The SQL query secondary tab opens by default when you make a connection to a server from the Home screen. It includes a query editor area and a toolbar. You can enter SQL statements directly into the query editor area.
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:
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.
197
C:\Users[WinUser]\AppData\Roaming\MySQL\Workbench\sql_history
you find a log file for each day. It includes manual and automated queries from workbench (e.g. UPDATES via edit in Table)
15
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
