Search code snippets, questions, articles...
All code snippets
Login
Register
+
Add new Snippet
Add new code snippet that you can easily search
Ask Question
If you stuck somewhere or want to start a discussion with dev community
Write Article
Share your knowledge by writing article and spread it
Chrome Extension
My Account
Browse
Javascript
React
Redux Form
Gulp
Javascript Basics
Vue.js
Chart.js
Lodash
Python
Python
SQLAlchemy
Django
Pandas
All
PHP
MySql
neo4j
AMP
Ubuntu
Flutter
Dart
Dev Tools
All
Code Manager
JSON Viewer
Javascript Runner
Comma Converter
HTML Editor
SCSS to CSS
SQL Formatter Online
Discussions
Articles
JSON Viewer
Dev Profile
More
Code snippets
Knowledgebase
About Us
Contact Us
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
Show all Databases MySQL
mysql
Share on :
To list all database in MySQL we use the query - SHOW DATABASES
Copy Code
SHOW DATABASES;
Contribute to this Snippet
Was this helpful?
Yes
No
Created by :
@
Write your Comment
0
Comments
Similar code snippets
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
Create your own code snippets and search them using our portal and chrome extension
Programming Feeds
Learn something new everyday on Devsheet
Important Links
Contribute to this Snippet
Join Devsheet
Create new snippet
Ask a Question
Write an article
Online JSON Viewer
Search code snippets, questions, articles...
Search code snippets, questions, articles...
0 Comments