USE database prompt

[Michael Welsh]

MySQL v 3.23.56 for pc-linux-gnu on i686

How do I know what database I am 'using' ?

I launch mysql from the command line. Type 'show databases', then pick a
database to use by typing 'use databasename'. I am now using that database
but have no visual cue.

How do I include the username, database name, etc in the 'mysql>' prompt?

Note, I can customize the command prompt on linux to include
user, host, directory, etc.. so I always know who I am and where I am.

Michael

end of message --------------------------------

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw