MySQL Tutorial

Profile picture for user devraj
Submitted by devraj on
MySQL Tutorial
MySQL Fundamentals
Introduction to SQL
Introduction to MySQL
History of MySQL
Features of MySQL
MySQL: Releases & Versions
MySQL Products & Editions
MySQL: Installation & Setup
Install MySQL workbench on Ubuntu 18.04
Download and Install MySQL Workbench on Windows 10 OS
MySQL Data Types
MySQL: Data Types List
MySQL: Numeric Data Types
MySQL: String Data Types
MySQL: Date and Time Data Types
Database Setup
MySQL: SHOW DATABASES Statement
MySQL: SELECT DATABASE Statement
MySQL: CREATE DATABASE Statement
MySQL: DROP DATABASE Statement
MySQL: Create User
Drop User in MySQL
MySQL Change User Password
MySQL Grant Privileges
MySQL Revoke Privileges
MySQL: Table
MySQL: CREATE TABLE Statement
MySQL: TRUNCATE TABLE statement
MySQL: Copy or Clone Table
MySQL: Rename Table
MySQL: Show or List Tables
MySQL: Create Table Using Another Table
MySQL: DROP TABLE Statement
MySQL: Describe Table
MySQL Repair Table
MySQL Show Table Columns
MySQL From Clause
Basic Queries
MySQL: SELECT Statement
MySQL: INSERT INTO Statement
MySQL: INSERT INTO SELECT Statement
MySQL REPLACE INTO
MySQL: WHERE Clause
MySQL: ORDER BY Clause
MySQL: Order by with Multiple columns
MySQL: Alias for Columns
MySQL Insert Ignore
MySQL: UPSERT using INSERT IGNORE
MySQL: UPSERT using REPLACE
MySQL: UPSERT using INSERT ON DUPLICATE KEY UPDATE
MySQL: Comments
MySQL Handling Duplicates
Update Query in MySQL
Delete Query in MySQL
MySQL Subquery
MySQL Derived Table
MySQL Constraints
MySQL NOT NULL
MySQL Primary Key
Composite Key MySQL
MySQL Foreign Key
MySQL Default Constraint
MySQL Constraints List
MySQL Unique Constraint
MySQL Check Constraint
On Delete Cascade MySQL
MySQL Auto Increment
MySQL Conditions
MySQL Operator
MySQL: AND Operator
MySQL: BETWEEN Operator
MYSQL: OR Operator
MySQL: Not Operator
MySQL: IN Operator
MySQL: LIKE Operator
MySQL: IS NULL Condition
MySQL: IS NOT NULL Condition
MySQL: Case Statement
MySQL: Union Operator
MySQL: REGEXP operator
MySQL Distinct
Count Function in MySQL
MySQL Count Distinct
MySQL IFNULL
MySQL Exists Operator
MySQL Operators
MySQL Logical Operators
MySQL Arithmetic Operators
MySQL Comparison Operators
MySQL Any Operator
MySQL All Operator
MySQL: Joins & Group By
MySQL: Types of Joins
MySQL: Inner Join
MySQL: Self Join
MySQL: Joining three tables
MySQL: Equi Join
MySQL: Left Join
MySQL: LEFT JOIN on Multiple Tables
MySQL: Right Join
MySQL: Cross Join
MySQL: Natural Join
MySQL Group By
Having Clause in MySQL
MySQL Delete From Inner Join
MySQL Alter
MySQL ALTER TABLE: Add columns in the existing table
MySQL ALTER TABLE: rename table
MySQL Rename Column
Alter Table Modify Column MySQL
MySQL Drop Column
MySQL Exporting & Importing Data
MySQL: Exporting Data using SELECT ... INTO OUTFILE
MySQL: Import CSV File in Database or Table
MySQL Control Flow Statement
MySQL: IF-THEN Statement
MySQL: IF-THEN-ELSE Statement
MySQL: IF-THEN-ELSEIF-ELSE Statement
MySQL Functions
MySQL: Average Function
MySQL: Numeric Functions List
MySQL: String Functions List
MySQL: Date Functions List
MySQL Functions (Advanced)
Sum Function in MySQL
MySQL Min Function
MySQL Max Function
MySQL Views
MySQL: CREATE VIEW Statement
MySQL Misc
MySQL Temporary Table
MySQL Lock User Account
IF Function in MySQL
MySQL NULLIF() Function
MySQL Partitioning
MySQL Partition Types
MySQL Indexing
MySQL Create Index
MySQL Unique Index
MySQL Show Indexes
MySQL Drop Index
MySQL Clustered Index
Lock
Read Lock MySQL
MySQL Lock Table for Write
MySQL Lock and Unlock Table