MySQL prompt一个特别好用的命令

2022-11-12 09:29:31

内容摘要

这篇文章主要为大家详细介绍了MySQL prompt一个特别好用的命令，具有一定的参考价值，可以用来参考一下。对此感兴趣的朋友，看看idc笔记做的技术笔记！想必大家在命令行操作mysq

文章正文

这篇文章主要为大家详细介绍了MySQL prompt一个特别好用的命令，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

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

代码如下:


[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

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

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 namesYou can turn off this feature to get a quicker startup with -A

Database changedroot@localhost:test 08:23:44>exit;

这样做的好处就是让我们大家在操作数据库时更加方便快捷。

您也可以在在my.cnf配置文件里进行配置：

代码如下:


[mysql]
prompt=mysql(\\u@\\h:\\d)>

default-character-set=utf8

代码如下:


[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

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

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 namesYou can turn off this feature to get a quicker startup with -A

Database changedmysql(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

注：关于MySQL prompt一个特别好用的命令的内容就先介绍到这里，更多相关文章的可以留意

代码注释

上一篇解决MySQL出现Can''t create/write to file ''#sql_5c0_0.MYD'&#下一篇 MySQL索引建立需要注意以下几点细节

作者：喵哥笔记

学的不仅是技术，更是梦想！