MySQL 客户端工具同样非常人性化 , 例如当查询结果集很多时,可以设置以列模式显示,还可以调用操作系统的命令显示。
先看一个查询
1 2 3 4 5 6 7
mysql> select * from information_schema.tables where table_name='test_1'; +--------------- +-------------- +------------ +------------ +-------- +--------- +------------ +------------ +---------------- +------------- +----------------- +-------------- +----------- +---------------- +--------------------- +------------- +------------ +----------------- +---------- +---------------- +--------------- + | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | +--------------- +-------------- +------------ +------------ +-------- +--------- +------------ +------------ +---------------- +------------- +----------------- +-------------- +----------- +---------------- +--------------------- +------------- +------------ +----------------- +---------- +---------------- +--------------- + | def | francs | test_1 | BASE TABLE | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 |NULL | 2014-08-14 09:30 :23 | NULL | NULL | utf8_general_ci |NULL | | | +--------------- +-------------- +------------ +------------ +-------- +--------- +------------ +------------ +---------------- +------------- +----------------- +-------------- +----------- +---------------- +--------------------- +------------- +------------ +----------------- +---------- +---------------- +--------------- + 1 row in set (0.00 sec)
备注:这个查询很长,不便于观看。
/G 设置列模式显示
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
mysql> select * from information_schema.tables where table_name='test_1'/G * 1. row * TABLE_CATALOG: def TABLE_SCHEMA: francs TABLE_NAME: test_1 TABLE_TYPE: BASE TABLE ENGINE: InnoDB VERSION: 10 ROW_FORMAT: Compact TABLE_ROWS: 3 AVG_ROW_LENGTH: 5461 DATA_LENGTH: 16384 MAX_DATA_LENGTH: 0 INDEX_LENGTH: 0 DATA_FREE: 0 AUTO_INCREMENT: NULL CREATE_TIME: 2014 -08 -14 09 :30:23 UPDATE_TIME: NULL CHECK_TIME: NULL TABLE_COLLATION: utf8_general_ci CHECKSUM: NULL CREATE_OPTIONS: TABLE_COMMENT: 1 row in set (0.00 sec)
备注: 在查询结尾使用G 代替分号便是以列模式显示,太棒了!
文档上的解释
1 2
ego, /G Send the current statement to the server to be executed and display the result using vertical format.
备注:如果查询结果很多, mysql 也能设置调用 OS 的系统命令显示查询结果,例如调用 linux 的 more, less 命令。
1 2
mysql> pager less PAGER set to 'less '
1 2
mysql> nopager ; PAGER set to stdout
备注: pager 可以调用操作系统命令显示结果例 ,例如 less, more 等, 确实很方便,同样 mysql 客户端的帮助命令也很人性化。
查看 Create Index 帮助命令
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
mysql> /h create index Name: 'CREATE INDEX' Description: Syntax: CREATE [UNIQUE |FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) [index_option] [algorithm_option | lock_option] ... index_col_name: col_name [(length )] [ASC | DESC ] index_type: USING {BTREE | HASH} index_option: KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name | COMMENT 'string' algorithm_option: ALGORITHM [=] {DEFAULT|INPLACE|COPY} lock_option: LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE} CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See [HELP ALTER TABLE]. CREATE INDEX cannot be used to create a PRIMARY KEY ; use ALTER TABLE instead. For more information about indexes, see http://dev.mysql.com/doc/refman/5.6/en/mysql-indexes.html. URL: http://dev.mysql.com/doc/refman/5.6/en/create -index .html
参考
MySQL Commands
原创文章,作者:3628473679,如若转载,请注明出处:https://blog.ytso.com/239595.html