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

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

Enter password:                         #老徐注释：输入密码51Testing软件测试网C(I%iT,\8j`

Welcome to the MySQL monitor.  Commands end with ; or \g.51Testing软件测试网3Ul6I-a,QE

Your MySQL connection id is 1051Testing软件测试网
x&jVHL

Server version: 5.6.23-log Source distribution51Testing软件测试网Q,R] aSv:N)h

51Testing软件测试网&pB0g/Wl

"{VV T!K9l k)t0

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

.FAM} nB[~0

:~aaz7oV0{m[,?051Testing软件测试网:E%o\x`

Oracle is a registered trademark of Oracle Corporation and/or its

`"C.x1B]E7Q+H0

affiliates. Other names may be trademarks of their respective

Ev:M(s8eX-Z0

owners.

$T3yTroi;E#P0

*A.TJ1MQ"G/UR0

t4X}}j8w1ZU]0

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.51Testing软件测试网H(d9uR1KA V

51Testing软件测试网m4J4].s)L
q-\._0keR

Pt }3I[Y0

mysql>      #老徐注释：如果看到如上信息代表已经进入mysql51Testing软件测试网3Y-I3MC4a2OJf

mysql> show databases;   #老徐注释：输入左侧命令，回车51Testing软件测试网0X0P/fll cD

+--------------------+51Testing软件测试网xfgE2Z tNH0s$eN

| Database           |

[&Z%W(U0MD0

+--------------------+51Testing软件测试网A].]dez8\ k`;Id

| information_schema |

&UQ+@&[GD[0

| mysql              |51Testing软件测试网(`h;Gd J;?6Xx-p

| performance_schema |

E:^c(X0TK7H0

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

vj5Hw(G
L#n0

3 rows in set (0.00 sec)

2Kk oq9a1Sqs1c0

Y^PnPd9z0

+Tzi S'JY B_t n2X;?0

mysql>     #老徐注释：如上就是显示当前存在的数据库

X.q'f CO"J:a4A0

mysql> use mysql     ＃老徐注释：左侧，use 表名，使用某个表51Testing软件测试网A5V9E/} gd!dJOWL

Database changed51Testing软件测试网d:T`A?,?T
_

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

O\
h T1Ke*x0

+---------------------------+51Testing软件测试网f(QG
sb/Fp"h

| Tables_in_mysql           |

:{X$@#TY\o@0

+---------------------------+51Testing软件测试网 z'P(km}1T
_

| columns_priv              |

FjU]'^m,U YNa0

| db                        |

!^~!OIT/nz7sA0

| event                     |51Testing软件测试网 RJ7\a/tyL1tS

| func                      |

AgI,P_~6A0

| general_log               |51Testing软件测试网 q&S'w.l]5x

| help_category             |51Testing软件测试网3e&I!nd3_:v.dAX/U6K

| help_keyword              |51Testing软件测试网MP&UH$wHoF

| help_relation             |51Testing软件测试网tE\"[0I3Yo

| help_topic                |

f9SVrC0J0

| innodb_index_stats        |51Testing软件测试网[ `$FOp X

| innodb_table_stats        |

y,K{*|q0

| ndb_binlog_index          |

9_MyYq(K6k d1C!fn0

| plugin                    |

4M}'_&[6Zk0

| proc                      |

R"y2sk+O%{X0

| procs_priv                |51Testing软件测试网@%\2z
x
N

| proxies_priv              |

r3vk)h.] m2eL0

| servers                   |51Testing软件测试网W/l4fUa {

| slave_master_info         |51Testing软件测试网u,{2D1D:b

| slave_relay_log_info      |51Testing软件测试网.Cp:Wy7?

| slave_worker_info         |51Testing软件测试网,X'vEo7J@m

| slow_log                  |51Testing软件测试网d
RkfH*P

| tables_priv               |

BxY(z7x,Fx0

| time_zone                 |

6q$GfZcZKt8Vp0

| time_zone_leap_second     |

?T4?2kw0

| time_zone_name            |51Testing软件测试网VH5Cl k6@W

| time_zone_transition      |

,M:oT&L"c z%U0

| time_zone_transition_type |

H.t]%QBH0

| user                      |51Testing软件测试网y^2C'L biP#M

+---------------------------+51Testing软件测试网 fx_t Tk/AI

28 rows in set (0.00 sec)51Testing软件测试网#i
y!_uc_i7S

51Testing软件测试网rulf5kk*b

\^+v'b*d7Ja4Ox7}%B0

mysql> 51Testing软件测试网$M%n%x1UWLD$|