易网时代-编程资源站

首页 / 数据库 / MySQL / mysql --prompt一个很好用的命令

想必大家在命令行操作mysql的时候会十分发愁现在的操作的是那个数据库吧，至少我就纠结过，可能您会说我打一条命令不就知道了，是的这样做确实可以的。可是今儿给大家介绍个好用的命令--prompt

[root@ www.linuxidc.com ~]# 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配置文件里进行配置：

[mysql]
prompt=mysql（\u@\h:\d）>
default-character-set=utf8

[root@ www.linuxidc.com ~]# vim /etc/my.cnf
[root@ www.linuxidc.com ~]# service mysqld restart
停止 MySQL： [确定]
启动 MySQL： [确定]
[root@ www.linuxidc.com ~]# 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
	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）
	The current time, standard 12-hour time （1–12）
`S`	Semicolon
`s`	Seconds of the current time
	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

探索Oracle之RMAN_07 磁盘损坏数据丢失恢复MySQL 5.5字符集问题相关资讯 MySQL教程

30分钟带你快速入门MySQL教程（02月03日）
MySQL教程：关于I/O内存方面的一些（01月24日）
CentOS上开启MySQL远程访问权限（01/29/2013 10:58:40）

MySQL教程：关于checkpoint机制（01月24日）
MySQL::Sandbox （04/14/2013 08:03:38）
生产环境MySQL 5.5.x单机多实例配（11/02/2012 21:02:36）

本文评论查看全部评论（0）