MySQL Tutorial

What is MySql
MySQL History
MySQL Advantages & Disadvantages
MySQL Features
Install MySQL Database Server on Window
Install MySQL Database Server on Linux

MySQL Database

Create Database
Select Database
Drop Database
Information About Databases

MySql Table

CREATE Table
ALTER Table
TRUNCATE Table
DROP Table
RENAME Table
TEMPORARY Table

MySQL Queries

INSERT Record
SELECT Record
UPDATE Record
DELETE Record
TRUNCATE Table
SUBQUERY

MySQL Clauses

MySQL WHERE
MySQL DISTINCT
MySQL FROM
MySQL ORDER BY
MySQL GROUP BY
MySQL HAVING
MySQL LIMIT

MySQL Operators

MySQL AND
MySQL OR
MySQL AND OR
MySQL LIKE
MySQL NOT LIKE
MySQL SOUNDS LIKE
MySQL REGEXP
MySQL CASE
MySQL DIV
MySQL MOD
MySQL IN
MySQL NOT
MySQL XOR
MySQL IS NULL
MySQL IS NOT NULL
MySQL BETWEEN
MySQL EXISTS
MySQL NOT EXISTS
MySQL ANY
MySQL ALL
MySQL UNION
MySQL MINUS
MySQL INTERSECT

MySQL Wildcards

MySQL Wildcards

MySQL Aliases

MySQL Aliases

MySQL Joins

MySql Inner Join
MySql Left Join
MySql Right Join
MySql Cross Join
MySql Self Join

MySQL Constraints

MySQL NOT NULL
MySQL UNIQUE
MySQL PRIMARY KEY
MySQL FOREIGN KEY
MySQL CHECK
MySQL INDEX

MySQL Data Types

MySQL Data Types

MySQL Aggregate Functions

MySQL count
MySQL sum
MySQL avg
MySQL min
MySQL max
MySQL first
MySQL last

MySQL Functions

MySQL Control Flow Functions
MySQL String Functions
MySQL Numeric Functions
MySQL Date and Time Functions
MySQL Information Functions
MySQL Cast Functions
MySQL Encryption and Compression Functions
MySQL JSON Function

MySQL Advanced

MySQL Stored Procedure
MySQL View
MySQL Trigger
MySQL Administration

MySQL Programming Interfaces

Python MySQL Tutorial
Perl MySQL Tutorial
Node.js MySQL Tutorial
PHP MySQL Tutorial
MySQL JDBC Tutorial

MySQL Interview Questions

MySQL Interview Questions and Answers


MySQL Show Info About Database

The SHOW DATABASE statement is used to display info about MySQL databases. An error occurs if the database not exists.

Syntax

SHOW DATABASES;

SHOW DATABASE Example

The following SQL statement Shows the existing databases:

Example 

SHOW DATABASES;

You can use MySQL Command Line Client to show MySQL databases. It will look like this:

Note: In order to create database, you must have admin privilege. All the database names, table names and table fields name are case sensitive. You must have to use proper names while giving any SQL command.

AngularJS Code Examples
AngularJS Live Demo
ASP.NET Code Examples
Javascript Code Examples
Interview Q & A
Google MAP API Live Demo
Google MAP API Code Examples
Utility Tools
Articles