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>"
Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks
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>"