SQL

mysql list databases

SHOW DATABASES;

mysql cli list databases

mysql -e 'show databases;' 

view databases in mysql

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| pets               |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

how to show current database in mysql

CopySELECT database();