Mysql应用mysql prompt一个特别好用的命令

发布时间：2020-12-12 00:59:50 所属栏目：MySql教程来源：网络整理

导读：《Mysql应用mysql prompt一个特别好用的命令》要点：本文介绍了Mysql应用mysql prompt一个特别好用的命令，希望对您有用。如果有疑问，可以联系我们。 MYSQL数据库想必大家在命令行操作mysql的时候会十分发愁现在的操作的是那个数据库吧,至少我就纠结过,可

c A counter that increments for each statement you issue D The full current date dThe 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 (0C23) r S Semicolon s Seconds of the current time t A tab character U

MYSQL数据库Your full?user_name@host_name?account name

uYour user name v The server version w The current day of the week in three-letter format (Mon,Tue,137); VERTICAL-ALIGN: baseline; BORDER-LEFT-WIDTH: 0px; FONT-WEIGHT: bold; PADDING-TOP: 0px" class="literal">Y The current year,four digits y _ A space ? A space (a space follows the backslash) ' Single quote " Double quote A literal “” backslash character x

MYSQL数据库x,for any “x” not listed above

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

Option	Description
《Mysql应用mysql prompt一个特别好用的命令》要点：本文介绍了Mysql应用mysql prompt一个特别好用的命令，希望对您有用。如果有疑问，可以联系我们。 MYSQL数据库想必大家在命令行操作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 MYSQL数据库Copyright (c) 2000,2011,Oracle and/or its affiliates. All rights reserved. MYSQL数据库Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. MYSQL数据库Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. MYSQL数据库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 MYSQL数据库Database changed root@localhost:test 08:23:44>exit; 这样做的好处就是让我们大家在操作数据库时更加方便快捷. MYSQL数据库您也可以在在my.cnf配置文件里进行配置：代码如下: [mysql] prompt=mysql(u@h:d)> MYSQL数据库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 MYSQL数据库Copyright (c) 2000,Oracle and/or its affiliates. All rights reserved. MYSQL数据库Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. MYSQL数据库Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. MYSQL数据库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 MYSQL数据库Database changed mysql(root@localhost:test)> 这里也给出需要的一些个选项供大家参考.

《Mysql应用mysql prompt一个特别好用的命令》要点：
本文介绍了Mysql应用mysql prompt一个特别好用的命令，希望对您有用。如果有疑问，可以联系我们。

MYSQL数据库想必大家在命令行操作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

MYSQL数据库Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

MYSQL数据库Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MYSQL数据库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

MYSQL数据库Database changed
root@localhost:test 08:23:44>exit;

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

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

代码如下:
[mysql]
prompt=mysql(u@h:d)>

MYSQL数据库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

MYSQL数据库Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

MYSQL数据库Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MYSQL数据库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

MYSQL数据库Database changed
mysql(root@localhost:test)>

这里也给出需要的一些个选项供大家参考.

Option

Description