当前位置：首页 > 资讯 > 技术文档

mysql prompt一个特别好用的命令

时间：2020-03-25 11:59 编辑：来源：阅读：
扫一扫，手机访问

摘要：mysql prompt一个特别好用的命令

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

[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配置文件里进行配置：

[u]复制代码[/u] 代码如下:

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

[u]复制代码[/u] 代码如下:

[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)>

[b]这里也给出需要的一些个选项供大家参考。 [/b]

Option	Description
[code]c[/code]	A counter that increments for each statement you issue
[code]D[/code]	The full current date
[code]d[/code]	[b]The default database[/b]
[code]h[/code]	[b]The server host[/b]
[code]l[/code]	[b]The current delimiter (new in 5.1.12)[/b]
[code]m[/code]	Minutes of the current time
[code]n[/code]	A newline character
[code]O[/code]	The current month in three-letter format (Jan, Feb, …)
[code]o[/code]	The current month in numeric format
[code]P[/code]	am/pm
[code]p[/code]	[b]The current TCP/IP port or socket file[/b]
[code]R[/code]	The current time, in 24-hour military time (0–23)
[code]r[/code]	The current time, standard 12-hour time (1–12)
[code]S[/code]	Semicolon
[code]s[/code]	Seconds of the current time
[code]t[/code]	A tab character
[code]U[/code]	[b]Your full [code]`user_name[/code]@[code]host_name[/code]` account name[/b]
[code]u[/code]	[b]Your user name[/b]
[code]v[/code]	The server version
[code]w[/code]	The current day of the week in three-letter format (Mon, Tue, …)
[code]Y[/code]	The current year, four digits
[code]y[/code]	The current year, two digits
[code]_[/code]	A space
[code] [/code]	A space (a space follows the backslash)
[code]'[/code]	Single quote
[code]"[/code]	Double quote
[code]\[/code]	A literal “[code][/code]” backslash character
[code]`x[/code]`	[code]x[/code], for any “[code]x[/code]” not listed above

全部评论(0)

上一篇：解决MySQL Workbench gnome-keyring-daemon错误的方法分享
下一篇：mysql安装图解 mysql图文安装教程(详细说明)

资讯排行榜
更多>>