mysql的歷史命令

lifeistrue

在mysql中，可以按向上方向鍵來調(diào)出以前的命令，如何取消該功能？mysql是不是有一個類似操作系統(tǒng)的
.bash_history文件來記錄歷史命令？如果有，該文件的位置是？謝謝了！

dangk

在你所使用的用戶的用戶目錄下
.mysql_history

lifeistrue

OK,謝謝樓上的！

lifeistrue

呵呵,一個新的問題,mysql有命令清空歷史命令嗎?在不手工編輯.mysql_history的情況下

dangk

On Unix, the mysql client writes a record of executed statements to a history file. By default, the history file is named .mysql_history and is created in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment variable.

If you do not want to maintain a history file, first remove .mysql_history if it exists, and then use either of the following techniques:

Set the MYSQL_HISTFILE variable to /dev/null. To cause this setting to take effect each time you log in, put the setting in one of your shell's startup files.

Create .mysql_history as a symbolic link to /dev/null:

shell> ln -s /dev/null $HOME/.mysql_history

You need do this only once.

lifeistrue

非常詳細的說明!謝謝!

dangk

是抄手冊的，赫赫

mgunix

cat  ~/.mysql_history