MySQL

SQL stands for Structured Query Language. It is used for storing and managing data in Relational Database Management System (RDBMS).
It is a standard language for Relational Database System. It enables a user to create, read, update and delete relational databases and tables.
All the RDBMS like MySQL, Informix, Oracle, MS Access and SQL Server use SQL as their standard database language.
SQL allows users to query the database in a number of ways, using English-like statements.
For example, MySQL, MongoDB, SQL Server, Oracle etc.

SQL follows the following rules:

• Structure query language is not case sensitive. Generally, keywords of SQL are written in uppercase.
• Statements of SQL are dependent on text lines. We can use a single SQL statement on one or multiple text line.
• Using the SQL statements, you can perform most of the actions in a database.
• SQL depends on tuple relational calculus and relational algebra.

Table of Contents 

What is SQL 

SQL Syntax

Types  of SQL Commands

SQL Data Types

SQL Operators

SQL Database

SQL CREATE Database

SQL DROP Database

SQL RENAME Database

SQL SELECT Database

What is Table

SQL CREATE TABLE

SQL DROP TABLE

SQL DELETE TABLE

SQL RENAME TABLE

SQL TRUNCATE TABLE

SQL COPY TABLE

SQL TEMP TABLE

SQL ALTER TABLE

SQL Select statement

SQL SELECT UNIQUE

SQL SELECT DISTINCT

SQL SELECT COUNT

SQL SELECT TOP

SQL SELECT FIRST

SQL SELECT LAST

SQL SELECT RANDOM

SQL SELECT IN

SQL SELECT Multiple

SQL SELECT DATE

SQL SELECT SUM

SQL SELECT NULL

SQL Clause

SQL WHERE

SQL AND

SQL OR

SQL WITH

SQL AS

SQL HAVING Clause

SQL Order By

ORDER BY Clause

ORDER BY ASC

ORDER BY DESC

ORDER BY RANDOM

ORDER BY LIMIT

ORDER BY Multiple Cols

SQL Insert

INSERT Statement

INSERT INTO Values

INSERT INTO SELECT

INSERT Multiple Rows

SQL Update

UPDATE Statement

SQL UPDATE JOIN

SQL UPDATE DATE

SQL Delete

DELETE Statement

SQL DELETE TABLE

SQL DELETE ROW

SQL DELETE All Rows

DELETE Duplicate Rows

SQL DELETE DATABASE

SQL DELETE VIEW

SQL DELETE JOIN

SQL Join

SQL JOIN

SQL Outer Join

SQL Left Join

SQL Right Join

SQL Full Join

SQL Cross Join

SQL Keys

Primary Key

Foreign Key

Composite Key

Unique Key

Alternate Key