千家信息网

MariaDB命令使用方式

发表于:2025-02-06 作者:千家信息网编辑
千家信息网最后更新 2025年02月06日,SELECT database();:显示当前使用的库[root@mariadb-1 ~]# mysqlWelcome to the MySQL monitor. Commands end with
千家信息网最后更新 2025年02月06日MariaDB命令使用方式
  • SELECT database();:显示当前使用的库

[root@mariadb-1 ~]# mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 13Server version: 8.0.16 MySQL Community Server - GPLCopyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.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 mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> SELECT database();+------------+| database() |+------------+| mysql      |+------------+1 row in set (0.00 sec)mysql>


0