mysqlprompt一个特别好用的命令_MySQL
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysqlprompt一个特别好用的命令_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2438字，纯文字阅读大概需要4分钟。
内容图文
bitsCN.com
想必大家在命令行操作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
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@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 |
内容总结
以上是互联网集市为您收集整理的mysqlprompt一个特别好用的命令_MySQL全部内容，希望文章能够帮你解决mysqlprompt一个特别好用的命令_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。