MYSQL数据库mysql prompt的用法详解
发布时间：2020-12-12 02:55:40 所属栏目：MySql教程 来源：网络整理
导读：《MYSQL数据库mysql prompt的用法详解》要点： 本文介绍了MYSQL数据库mysql prompt的用法详解，希望对您有用。如果有疑问，可以联系我们。 prompt命令可以在mysql提示符中显示当前用户、数据库、时间等信息 代码如下: mysql -uroot -p --prompt="u@h:d
|
《MYSQL数据库mysql prompt的用法详解》要点： 代码如下: mysql -uroot -p --prompt="u@h:d r:m:s>" 设置成功后： 代码如下: Welcome to the MySQL monitor.? Commands end with ; or g. Your MySQL connection id is 5 Server version: 5.1.60-log Source distribution Copyright (c) 2000,2012,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) 11:04:23> 也可以在在my.cnf配置文件里进行配置： 代码如下: [mysql]? prompt=mysql(u@h:d)>? default-character-set=utf8? 选项说明: 代码如下: 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 (0C23) r? The current time,standard 12-hour time (1C12) S? Semicolon s? Seconds of the current time t? A tab character U?? www.aspzz.cn? 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数据库mysql prompt的用法详解》是否对您有启发，欢迎查看更多与《MYSQL数据库mysql prompt的用法详解》相关教程，学精学透。编程之家PHP学院为您提供精彩教程。 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |