Linux下MySQL快捷键

Linux下MySQL快捷键

 

 

\c：clear 清除命令行

 \h：h create table 帮助文档

tab：show tables; select * from proc  按下tab键就会显示当前数据库下有哪些表

\G：select * from xx \G 查询出来的结果会以grid的形式显示  不需要输入分号来执行，输入了\G之后马上就可以执行

 

 

mysql> select * from \c
mysql> \h create table

Name: 'CREATE TABLE'
Description:
Syntax:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
(create_definition,...)
[table_options]
[partition_options]

Or:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name

 

 

 

mysql> select * from `mysql`.`user` \G

*************************** 1. row ***************************
Host: localhost
User: root
Password: *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
Select_priv: Y
Insert_priv: Y
Update_priv: Y