mysql 命令行操作入门（详细讲解版）

[root@localhost~]# mysql -u root -p    #老徐注释：输入左侧命令，回车 root是用户名

Enter password:                         #老徐注释：输入密码

0T;u Y9dg|0

Welcome to the MySQL monitor.  Commands end with ; or \g.

6?:g~;R;db)m~0

Your MySQL connection id is 1051Testing软件测试网;U \r0al"_n.N2j

Server version: 5.6.23-log Source distribution51Testing软件测试网9]X:TNZ ?b"} N

!ZbO]2i6DrG051Testing软件测试网DU+h"y*]S$hq@H

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

+@p
@(iJ*_s;b
T0

51Testing软件测试网0Ng1N*q2FO [ w
51Testing软件测试网k7No{.IWS+_4R

Oracle is a registered trademark of Oracle Corporation and/or its51Testing软件测试网 y5n6kHCd)[$A

affiliates. Other names may be trademarks of their respective

PK5fo[7~'cVO0

owners.51Testing软件测试网,?0lp1u.hg-{

51Testing软件测试网X?q4]3Wu^ h

O(gNtXJ|TU.t&o1w0

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

b
M%U5KOf+I0

51Testing软件测试网wMa5O @} a]
51Testing软件测试网A^k2pW g

mysql>      #老徐注释：如果看到如上信息代表已经进入mysql

.H?c}Lh0XV0

mysql> show databases;   #老徐注释：输入左侧命令，回车

5} Ug YZM U2z1a0

+--------------------+51Testing软件测试网Z*hiZ/YKi/e

| Database           |51Testing软件测试网F$~)ti#uO

+--------------------+51Testing软件测试网6nR_ NB-t'X6\6l)B

| information_schema |51Testing软件测试网P0Ap&?}6L^cYp N:G1g

| mysql              |

QX+p3pA_0

| performance_schema |51Testing软件测试网orZK4|cE

+--------------------+

\A9B Jh}0

3 rows in set (0.00 sec)51Testing软件测试网%TI
?XGP&q!w0ex

51Testing软件测试网OK^)m0x
k
51Testing软件测试网lFOk&u:Y6A

mysql>     #老徐注释：如上就是显示当前存在的数据库51Testing软件测试网3M6KJV_'a
@{

mysql> use mysql     ＃老徐注释：左侧，use 表名，使用某个表51Testing软件测试网|vn@Tg7Kc

Database changed

"t*}-m8`1c e4T8X y0

mysql> show tables;  ＃老徐注释：显示当前数据库下的所有表名

j2`i9P;A&MGxv0

+---------------------------+

4k;C/A,J|zF9M^8w&w8r0

| Tables_in_mysql           |51Testing软件测试网7Vy|8?|5u

+---------------------------+51Testing软件测试网3o wb U3hU'{cC(v

| columns_priv              |51Testing软件测试网EhbpIy ~sDF

| db                        |51Testing软件测试网#f2y1w:\%S4F

| event                     |

,qNq+C c9HJ_0

| func                      |51Testing软件测试网w%RS WKW'j

| general_log               |51Testing软件测试网r"LA9["^ r/r

| help_category             |51Testing软件测试网|4y
Ty9ab!O6d

| help_keyword              |51Testing软件测试网gA\K+i$Bo%dM

| help_relation             |51Testing软件测试网!ekG
l'Y-^S'^6uKQ

| help_topic                |

+b g)j2]U@(P$r0

| innodb_index_stats        |

;R5P1yEcDy_B-j0

| innodb_table_stats        |51Testing软件测试网-p BHRD S7tZk$U

| ndb_binlog_index          |51Testing软件测试网*X$CEf lzOvj.r

| plugin                    |

3w!wX F/y9P0

| proc                      |51Testing软件测试网1ao,E;d(T(|(g

| procs_priv                |

z&w0@f9? Ba_0

| proxies_priv              |

.e~]'}`9rXLB4@0

| servers                   |

3B(C^}+| f0

| slave_master_info         |

;MBZ3P7T-A q5VF0

| slave_relay_log_info      |51Testing软件测试网Q/t#N'IF-I,EZ

| slave_worker_info         |

b'e.v l!G"GV0

| slow_log                  |

n3u'Z |2Jf,}E0

| tables_priv               |

7EJC:v&H]#^/`#b%e_*N0

| time_zone                 |

uV(H%H2|v j~V0

| time_zone_leap_second     |

$W \Yv'H0

| time_zone_name            |51Testing软件测试网 LMJ5[,L1D

| time_zone_transition      |

~3C O;hRa
@0

| time_zone_transition_type |

&|Hk#\N6]KU0

| user                      |

iZ{|.|T0

+---------------------------+51Testing软件测试网}M!G*xL8dO

28 rows in set (0.00 sec)51Testing软件测试网jKM!B[1fO

2d.q;u@ H)zz051Testing软件测试网Rm/c9lf7{

mysql> 

Uq-Gfo8tY]d0