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?
Yes
No
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
Create new account
Login Now
Generating new answer. Please wait...
×
