MySQL prompt Command

(This was tested on MySQL running on UNIX.)

 

You can change your MySQL prompt by using the prompt command:
  

mysql>prompt Andrew >

PROMPT set to 'Andrew > '

Andrew >