MariaDB命令使用方式

• SELECT database();：顯示當(dāng)前使用的庫(kù)

[root@mariadb-1?~]#?mysql
Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?\g.
Your?MySQL?connection?id?is?13
Server?version:?8.0.16?MySQL?Community?Server?-?GPL

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

Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its
affiliates.?Other?names?may?be?trademarks?of?their?respective
owners.

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

mysql>?SELECT?database();
+------------+
|?database()?|
+------------+
|?NULL???????|
+------------+
1?row?in?set?(0.00?sec)

mysql>?SHOW?DATABASES;
+--------------------+
|?Database???????????|
+--------------------+
|?information_schema?|
|?mysql??????????????|
|?performance_schema?|
|?sys????????????????|
+--------------------+
4?rows?in?set?(0.01?sec)

mysql>?use?mysql
Reading?table?information?for?completion?of?table?and?column?names
You?can?turn?off?this?feature?to?get?a?quicker?startup?with?-A

Database?changed
mysql>?SELECT?database();
+------------+
|?database()?|
+------------+
|?mysql??????|
+------------+
1?row?in?set?(0.00?sec)

mysql>