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