Chang the Mysql client prompt

Changing the Mysql client prompt: (Mysql 4.0.2 and higher)

(from http://dev.mysql.com/doc/mysql/en/mysql_Commands.html)

e.g. "prompt \d\R\m>" will show the current database + millitary hour + minutes

Put in my.cnf

[mysql]
prompt="\\d\\R\\m>"

Thank you for reading this article Chang the Mysql client prompt With URL http://x-tutorials.blogspot.com/2005/04/chang-mysql-client-prompt.html. Also a time to read the other articles.