Mysql sql history(cross session)

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have found many docs to see is there any way to figure out how can
mysql store the typed words or sql(whatever it is a valid sql or not)
so that we can just use "arrow up" or "arrow down"
easily to move to the previous sql or even some sqls typed yesterday or
in different sessions(such as by putty/konsole) that is already logged
out ?

Does anyone have any clues about this ? I think that it should be done
by setting some
mysql server vairables but i didn't see any mentioned in the mysql


Re: Mysql sql history(cross session)

Quoted text here. Click to load it

If you use UNIX or Linux, the commands are stored in a file called
".mysql_history" in your home directory.  You can also specify the location
of the file.  Some usage of the mysql tool alters the history storage.  Read
the docs for more information:

The docs do not indicate how history storage is done if you use a Windows

Bill K.

Site Timeline