mysql prompt一个很好用的命令_MySQL

bitsCN.com mysql prompt一个很好用的命令 想必大家在命令行操作mysql的时候会十分发愁现在的操作的是那个数据库吧，至少我就纠结过，可能您会说我打一条命令不就知道了，是的这样做确实可以的。 可是今儿给大家介绍个好用的命令--prompt [html]  [root@fsailing1 ~]# mysql -uroot -p --prompt="//u@//h://d //r://m://s>"  Enter password:  Welcome to the MySQL monitor.  Commands end with ; or /g.  Your MySQL connection id is 378      Server version: 5.0.95 Source distribution    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.    Oracle is a registered trademark of Oracle Corporation and/or its  affiliates. Other names may be trademarks of their respective  owners.    Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.    root@localhost:(none) 08:23:32>use test;  
 Reading table information for completion of table and column names  You can turn off this feature to get a quicker startup with -A    Database changed  root@localhost:test 08:23:44>exit;  
 这样做的好处就是让我们大家在操作数据库时更加方便快捷。
 您也可以在在my.cnf配置文件里进行配置：
 [html]  [mysql]  prompt=mysql(//u@//h://d)>    default-character-set=utf8  [html]  [root@fsailing1 ~]# vim /etc/my.cnf  [root@fsailing1 ~]# service mysqld restart  停止 MySQL：                                               [确定]  启动 MySQL：                                               [确定]  [root@fsailing1 ~]# mysql -uroot -p  Enter password:  Welcome to the MySQL monitor.  Commands end with ; or /g.  Your MySQL connection id is 2      Server version: 5.0.95 Source distribution    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.    Oracle is a registered trademark of Oracle Corporation and/or its  affiliates. Other names may be trademarks of their respective  owners.    Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.    mysql(root@localhost:(none))>use test;  Reading table information for completion of table and column names  You can turn off this feature to get a quicker startup with -A    Database changed  mysql(root@localhost:test)>  
 这里也给出需要的一些个选项供大家参考。
 Option Description/c A counter that increments for each statement you issue/D The full current date/d The default database/h The server host/l The current delimiter (new in 5.1.12)/m Minutes of the current time/n A newline character/O The current month in three-letter format (Jan, Feb, …)/o The current month in numeric format/P am/pm/p The current TCP/IP port or socket file/R The current time, in 24-hour military time (0–23)/r The current time, standard 12-hour time (1–12)/S Semicolon/s Seconds of the current time/t A tab character/U    Your full user_name@host_name account name /u Your user name/v The server version/w The current day of the week in three-letter format (Mon, Tue, …)/Y The current year, four digits/y The current year, two digits/_ A space/ A space (a space follows the backslash)/' Single quote/" Double quote// A literal “/” backslash character/x x, for any “x” not listed above   作者 chen861201 bitsCN.com