MySQL Tutorial

MySQL is a widely used, open-source relational database management system (RDBMS). It is based on the Structured Query Language (SQL) and is commonly used in web applications to store and retrieve data. MySQL supports a wide variety of data types, including numerical, string, and date types, and allows for the creation of complex relationships between tables using keys and indexes. It also offers many features for data security, performance optimization, and backup and recovery. MySQL can be used on a variety of operating systems, including Windows, Linux, and macOS.

MySQL-How To

MySQL Interview Questions

Web Stories

MySQL Tutorial

MySQL Features
MySQL Versions
MySQL Data Types
MySQL Variables
How to install MySQL
MySQL Connection
MySQL Workbench
MySQL Create User
MySQL Drop User
MySQL Show Users
Change MySQL User Password
MySQL Create Database
MySQL SELECT Database
MySQL Show/List Databases
MySQL DROP Database
MySQL COPY Database
MySQL CREATE TABLE
MySQL ALTER Table
MySQL Show/List 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 View
MySQL Table Locking
MySQL Lock Account
MySQL Unlock Account
MySQL Queries
MySQL Constraints
MySQL INSERT Statement
MySQL UPDATE
MySQL DELETE Statement
MySQL SELECT Statement
MySQL REPLACE
MySQL INSERT ON DUPLICATE KEY UPDATE
MySQL INSERT IGNORE
MySQL INSERT INTO SELECT
How to Create Index in MySQL
MySQL Drop Index
MySQL Show Indexes
MySQL UNIQUE INDEX
MySQL Clustered Index
Difference between MySQL Clustered and Non-Clustered Index
MySQL WHERE Clause
MySQL Distinct Clause
MySQL FROM Clause
MySQL ORDER BY Clause
MySQL GROUP BY Clause
MySQL HAVING Clause
MySQL Grant Privilege
MySQL Revoke Privilege
MySQL IF()
MySQL IFNULL()
MySQL NULLIF()
MySQL CASE Expression
MySQL IF Statement
MySQL AND Condition
MySQL OR Condition
MySQL AND & OR condition
MySQL Boolean
MySQL LIKE condition
MySQL IN Condition
MySQL ANY
MySQL Exists
MySQL NOT Condition
MySQL Not Equal
MySQL IS NULL Condition
MySQL IS NOT NULL Condition
MySQL BETWEEN Condition
MySQL JOINS
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
MySQL Difference between Left Join and Right Join
Difference between MySQL Union and Join
MySQL Unique Key
MySQL Primary Key
MySQL Foreign Key
MySQL Composite Key
MySQL Trigger
MySQL Create Trigger
MySQL Show/List Triggers
MySQL DROP Trigger
MySQL BEFORE INSERT TRIGGER
MySQL AFTER INSERT Trigger
MySQL BEFORE UPDATE Trigger
MySQL AFTER UPDATE TRIGGER
MySQL BEFORE DELETE Trigger
MySQL AFTER DELETE Trigger
MySQL Aggregate Functions
MySQL Count() Function
MySQL sum() function
MySQL avg() function
MySQL MIN() Function
MySQL MAX() Function
MySQL GROUP_CONCAT() Function
MySQL first function
MySQL last function
MySQL Comments
MySQL CHECK CONSTRAINT
MySQL Change Storage Engine
MySQL Export and Import Database
MySQL Import CSV File in Database/Table
MySQL Export Table to CSV
MySQL Subquery
MySQL Derived Table
MySQL UUID
MySQL LEAD and LAG Function
MySQL Common Table Expression (CTE)
MySQL ON DELETE CASCADE
MySQL UPSERT
MySQL Commands/Cheat-Sheet
MySQL Transaction
What is partitioning in MySQL?
MySQL ROW_NUMBER() Function
MySQL Cursor
MySQL Limit
MySQL Stored Function
MySQL Number Format Function
MySQL Ranking Functions
MySQL Window Functions
MySQL Union
MySQL Difference between Union and Union All
MySQL VARCHAR
MySQL ENUM
MySQL SET
MySQL DECIMAL
MySQL CAST() Function
MySQL Convert() Function
MySQL COALESCE() Function
MySQL Wildcards
MySQL Alias
MySQL Functions
MySQL ROLLUP
MySQL INT
MySQL Today
MySQL ROW COUNT
MySQL Prepared Statement
MySQL Literals (Constants)
MySQL Literals: Date and Time
MySQL Stored Procedure
MySQL MINUS
MySQL INTERSECT
MySQL Table Types/Storage Engines
MySQL EXPLAIN
MySQL SEQUENCE
MySQL JSON
MySQL Standard Deviation
MySQL Find Duplicate Records
MySQL Delete Duplicate Records
MySQL Select Random Records
MySQL Extract
MySQL SHOW PROCESSLIST
MySQL BIT
MySQL Change Column Type
MySQL RESET AUTO INCREMENT
MySQL INTERVAL
MySQL Login with Different User Account
MySQL Character Set
MySQL Collation
MySQL Regular Expressions
MySQL RLIKE Operator
MySQL NOT LIKE Operator
MySQL NOT REGEXP Operator
MySQL REGEXP Operator
MySQL REGEXP_INSTR() Function
MySQL REGEXP_LIKE() Function
MySQL REGEXP_REPLACE() Function
MySQL REGEXP_SUBSTR() Function
MySQL FULLTEXT SEARCH (FTS)
MySQL Natural Language FULLTEXT Search
MySQL BOOLEAN FULLTEXT SEARCH
MySQL Query Expansion FULLTEXT Search
MySQL ngram Full-Text Parser
Difference between MySQL and MongoDB
Difference between MySQL and MS SQL Server
Difference between MySQL and Oracle
Difference between MariaDB and MySQL
Difference between PostgreSQL and MySQL
Difference between MySQL and SQL
MySQL Difference between Table and View
MySQL Difference between Delete and Truncate Command
MySQL Difference between Database and Schema
MySQL Difference between Primary Key and Foreign Key
MySQL Difference between Primary Key and Unique key
MySQL Difference between Primary Key and Candidate Key