Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 8: How do you customize the mysql prompt? – MySQL Question of the Day

Skip to content

Question 8: How do you customize the mysql prompt?

5. February 2010
By urs in mysql questions

1 Comment

 
(Find all correct answers)

a) (inside the mysql-client) prompt \U \d :
b) (inside the windows command shell) set MYSQL_PS1=\U \d :
    (or inside a unix shell)  export MYSQL_PS1="\U \d : "
c) mysql -p -u root --prompt="\U \d : "

 
[ The mysql Client Program (10%) - The mysql Prompts ]
 

Tags: , ,

Comment Feed

One Response

  1. urs — 5. February 2010 @ 13:46:30 —

    Answers:

    a b c

    Additionally you can set the prompt in a config file like my.cfg.

You must be logged in to post a comment.