MySQL Tutorial

• MySQL Tutorial
• MySQL Features
• MySQL Versions
• MySQL Data Types
• MySQL Variables
• Install MySQL
• MySQL Connection

MySQL Workbench

• MySQL Workbench

User Management

• MySQL Create User
• MySQL Drop User
• MySQL Show Users
• Change User Password

MySQL Database

• MySQL Create Database
• MySQL Select Database
• MySQL Show Databases
• MySQL Drop Database
• MySQL Copy Database

Table & Views

• MySQL CREATE Table
• MySQL ALTER Table
• MySQL Show Tables
• MySQL Rename Table
• MySQL TRUNCATE Table
• MySQL Describe Table
• MySQL DROP Table
• MySQL Temporary Table
• MySQL Copy Table
• MySQL Repair Table
• MySQL Add/Delete Column
• MySQL Show Columns
• MySQL Rename Column
• MySQL Views
• MySQL Table Locking
• MySQL Account Lock

MySQL Queries

• MySQL SELECT Record
• MySQL Replace
• Insert On Duplicate Key Update
• MySQL INSERT IGNORE
• Insert Into Select

MySQL Indexes

• MySQL Create Index
• MySQL Drop Index
• MySQL Show Indexes
• MySQL Unique Index
• MySQL Clustered Index
• MySQL Clustered vs Non-Clustered Index

MySQL Clauses

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

MySQL Privileges

• MySQL Grant Privilege
• MySQL Revoke Privilege

Control Flow Function

• MySQL IF()
• MySQL IFNULL()
• MySQL NULLIF()
• MySQL CASE
• MySQL IF Statement

MySQL Conditions

• MySQL AND
• MySQL OR
• MySQL AND OR
• MySQL Boolean
• MySQL LIKE
• MySQL IN
• MySQL ANY
• MySQL Exists
• MySQL NOT
• MySQL Not Equal
• MySQL IS NULL
• MySQL IS NOT NULL
• MySQL BETWEEN

MySQL Join

• MySQL JOIN
• MySQL Inner Join
• MySQL Left Join
• MySQL Right Join
• MySQL CROSS JOIN
• MySQL SELF JOIN
• MySQL DELETE JOIN
• MySQL Update Join
• MySQL EquiJoin
• MySQL Natural Join
• Left Join vs Right Join
• MySQL Union vs Join

MySQL Key

• MySQL Unique Key
• MySQL Primary Key
• MySQL Foreign Key
• MySQL Composite Key

MySQL Triggers

• MySQL Trigger
• MySQL Create Trigger
• MySQL Show Trigger
• MySQL DROP Trigger
• Before Insert Trigger
• After Insert Trigger
• MySQL BEFORE UPDATE Trigger
• MySQL AFTER UPDATE Trigger
• MySQL BEFORE DELETE Trigger
• MySQL AFTER DELETE Trigger

Aggregate Functions

• MySQL Aggregate Functions
• MySQL count()
• MySQL sum()
• MySQL avg()
• MySQL min()
• MySQL max()
• MySQL GROUP_CONCAT()
• MySQL first()
• MySQL last()

MySQL Misc

• MySQL Comments
• Export & Import Database
• Import CSV File in Database
• Export Table to CSV
• MySQL Subquery
• MySQL Derived Table
• MySQL UUID
• LEAD And LAG Function
• MySQL CTE
• MySQL On Delete Cascade
• MySQL UPSERT
• MySQL Commands Cheat-Sheet
• MySQL Transaction
• MySQL Partitioning
• MySQL ROW_NUMBER()
• MySQL Cursor
• MySQL Limit
• MySQL Stored Function
• MySQL Signal Resignal
• Number Format Function
• MySQL Ranking Functions
• MySQL Window Functions
• MySQL Union
• Union vs Union All
• MySQL VARCHAR
• MySQL ENUM
• MySQL SET
• MySQL DECIMAL
• MySQL CAST
• MySQL Convert()
• MySQL COALESCE()
• MySQL Wildcards
• MySQL Alias
• MySQL Functions
• MySQL ROLLUP
• MySQL INT
• MySQL Today
• MySQL ROW COUNT
• Prepared Statement
• MySQL Literals(Constants)
• MySQL Date & Time
• MySQL Procedure
• MySQL Minus
• MySQL Intersect
• MySQL Storage Engines
• MySQL Explain
• MySQL Sequence
• MySQL JSON
• MySQL Standard Deviation
• How to select nth Highest Record
• Find Duplicate Records
• Delete Duplicate Records
• MySQL Select Random Records
• MySQL Extract
• MySQL ProcessList
• MySQL BIT
• Change Column Type
• MySQL Reset Auto-Increment
• MySQL Interval
• Login with Different User

MySQL Globalisation

• MySQL Character Set
• MySQL Collation

Regular Expressions

• Regular Expressions
• MySQL RLIKE
• Not Like Operator
• Not regexp Operator
• regexp Operator
• regexp_instr() Function
• regexp_like() Function
• regexp_replace() Function
• regexp_substr() Function

FULLTEXT Search

• MySQL Fulltext Search
• Natural Language Fulltext Search
• Boolean Fulltext Search
• Query Expansion Fulltext Search
• ngram Fulltext Parser

Differences

• MySQL vs MongoDB
• MySQL vs MS SQL Server
• MySQL vs Oracle
• MariaDB vs MySQL
• PostgreSQL vs MySQL
• MySQL vs SQL
• Table vs View
• Delete vs Truncate Command
• Database vs Schema
• Primary Key vs Foreign Key
• Primary Key vs Unique key
• Primary Key vs Candidate Key

Interview Questions

• MySQL Interview
• SQL Interview
• PL/SQL Interview