mysql 查询记录创建表,MySQL工作台查询历史记录（最后执行的查询/查询），即创建/更改表，选择，插入更新查询...

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

解决方案

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.