MYSQL入门学习之十六：MYSQL命令参数详解(三)
MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.1.28-rc-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show variables like '%char%';
+--------------------------+------------------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:\APMServ5.2.6\MySQL5.1\share\charsets\ |
+--------------------------+------------------------------------------+
C:\Users\qxl>mysql -uroot -D test --delimiter=//
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.28-rc-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use test//
Database changed
mysql> select count(*) from test.newname//
C:\Users\qxl>mysql -uroot -D mysql -e "show tables;" -H
| Tables_in_mysql | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| columns_priv | ||||||||||||||||
| db | event | |||||||||||||||
| func | ||||||||||||||||
| general_log | ||||||||||||||||
| help_category | <||||||||||||||||
| help_keyword | ||||||||||||||||
| help_relation | ||||||||||||||||
| help_topic | ||||||||||||||||
|
>host | ||||||||||||||||
| ndb_binlog_index | ||||||||||||||||
| plugin | ||||||||||||||||
| proc | ||||||||||||||||
| servers | ||||||||||||||||
| slow_log | ||||||||||||||||
| tables_priv | ||||||||||||||||
| time_zone | ||||||||||||||||
| time_zone_leap_second | ||||||||||||||||
| time_zone_name | ||||||||||||||||
| time_zone_transition | ||||||||||||||||
| time_zone_transition_type | ||||||||||||||||
| user | <
C:\Users\qxl>mysql -uroot -D mysql -e "show tables;" -X
< xml version="1.0" >
www.2cto.com
C:\Users\qxl>mysql -uroot -D mysql --prompt="this is my database!"
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.1.28-rc-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
this is my database!