devsheet logo Devsheet
My Feed Posts
Tools
JSON Viewer Javascript Runner Comma Converter HTML Editor SCSS to CSS SQL Formatter Online
MySQL Basics
  • Add comment
  • CREATE Database
  • Create Table
  • Show Databases
  • Show Tables
  • Insert data into table
  • UNIQUE CONSTRAINT
  • ALTER TABLE
  • RENAME TABLE
  • DROP TABLE
  • Delete a column
MySQL Select
  • Select rows
  • Add Foreign Key
  • ORDER BY
  • DISTINCT Records
  • Select Duplicate Rows and its counts
  • IN Operator
  • Order by Date where date in string format MySQL
MySQL Examples
  • Apply JOIN on multiple columns of the tables MySql
  • Select second highest column value MySQL
  • Show column names of a table MySql
  • Get table information in MySQL
  • MySQL Query to change column type
  • Add a Boolean column in MySQL table with default value
mysql

Show all Databases MySQL

To list all database in MySQL we use the query - SHOW DATABASES

SHOW DATABASES;
Was this helpful?
Similar Posts
  • Show all tables in a database MySQL
  • Show all column names of a table MySql query
  • Create table with constraints MySQL query
  • Insert data into table mysql query
  • Get duplicate rows and its counts MySQL
  • Add foreign key in existing table Mysql
  • Order by ascending and descending MySQL
Search all posts...
Programmer's Homepage
Your One-Stop Chrome Extension for Curated Developer Feeds, Where Learning and Growth Never Stop!
Connect using Github
  • Sign up
  • Login
Generating new answer. Please wait...