Re: [Squirrel-sql-users] delete a SQL statement from my SQL history

[selim ok <se...@gm...>]

Hi There,

I just see your post as I searched on google how to remove squirrel SQL
history.
After I realized how to do, I want to post my answer to help others, who
will possibly search the same topic on google or somewhere else.

It need a bit manual work:

Under linux (possibly the same for other platforms) squirrel creates a
directory on your home folder, which called .squirrel-sql (attention:
directories starts with a dot may be hidden). In this folder there is a
file called sql_history.xml, which contains all SQL history until now
stored. But the last executed commands are not saved until the squirrel
client gui closed. If you entered some sensible commands, you have to
terminate the gui and after then you can remove the content of the
sql_history.xml file. So the SQL History is removed.

Cheers,
Selim


From: Thorsten Berninger <thorsten.berninger@go...> - 2011-05-16 10:39

Hi everybody,

I would like to delete a SQL statement from my SQL history (100).
I used SQuirreL to change my password (sp_password 'old', 'new')
and now can everybody see my new password in the SQL history.


Bye the way: why is it not possible to search in the help menu?

best regards