Getting Started with MariaDB - Second Edition by Bartholomew Daniel

Author:Bartholomew, Daniel [Bartholomew, Daniel]
Language: eng
Format: azw3
Publisher: Packt Publishing
Published: 2015-06-16T16:00:00+00:00

Using SHOW to list all databases on a server

To show a list of all of the databases on a server that the current user is allowed to see, use the SHOW DATABASES command as in the following example:

MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | dbt3_s001 | | flightstats | | ham | | information_schema | | isfdb | | lds_scriptures | | library | | mysql | | performance_schema | | test | | wikidb | +--------------------+ 11 rows in set (0.00 sec) MariaDB [(none)]>

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.