Re: SQL mode and history

[Tim X]

Richard Riley <rileyrg@googlemail.com> writes:

> I'm looking for a working set up which saves and restores the mysql history in
> SQL mode.
>
> thanks,
>
> r.
>
>

It is already built into sql-mode. You need to define a file for the
history to be stored in. 

,----[ C-h v sql-input-ring-file-name RET ]
| sql-input-ring-file-name is a variable defined in `sql.el'.
| Its value is nil
| 
| Documentation:
| If non-nil, name of the file to read/write input history.
| 
| You have to set this variable if you want the history of your commands
| saved from one Emacs session to the next.  If this variable is set,
| exiting the SQL interpreter in an SQLi buffer will write the input
| history to the specified file.  Starting a new process in a SQLi buffer
| will read the input history from the specified file.
| 
| This is used to initialize `comint-input-ring-file-name'.
| 
| Note that the size of the input history is determined by the variable
| `comint-input-ring-size'.
| 
| You can customize this variable.
| 
| [back]
`----

-- 
tcross (at) rapttech dot com dot au