Account
Login
Categories
HTML
CSS
Python
PHP
MySQL
Linux
MySQL Tutorial
Introduction to MySQL
What is MySQL?
Key Features of Mysql
MySQL Data Type
Types of Data Types in MySQL
Numeric Data Type
String Data Type
Date and Time Data Type
Boolean Data Type
ENUM Data Type
SET Data Type
JSON Data Type
Spatial Data Types
MySQL CREATE DATABASE Command
MySQL USE command
MySQL SHOW DATABASES command
MySQL DROP DATABASE Command
MySQL CREATE TABLE Command
MySQL SHOW TABLES Command
MySQL DESC Command
MySQL View Table Structure : DESC Command
SELECT Command: Specific Columns
SELECT Command: All Data
TRUNCATE TABLE Command
UPDATE Command
DELETE Command
What is a Schema in SQL?
MySQL Constraints and Their Uses
Primary Key
Foreign Key
UNIQUE Constraint
NOT NULL Constraint
CHECK Constraint
DEFAULT Constraint
Joins: Definition and Types
INNER JOIN: Retrieve Common Records
LEFT JOIN: Retrieve Unmatched Right Table Records
RIGHT JOIN: Retrieve Unmatched Left Table Records
FULL JOIN: Retrieve Data from Both Tables
SELF JOIN: Compare Data Within Same Table
CROSS JOIN: Cartesian Product of Tables
MySQL Functions: Definition and Types
String Functions: Types and Uses
MySQL CONCAT()
MySQL LENGTH()
MySQL SUBSTRING()
MySQL REPLACE()
Numeric Functions: Types and Their Uses
MySQL ROUND()
MySQL CEIL()
MySQL FLOOR()
Date and Time Functions: Types and Their Uses
MySQL NOW()
MySQL CURDATE()
MySQL DATEDIFF()
MySQL TIMESTAMPDIFF()
Aggregate Functions: Types and Their Uses
MySQL COUNT()
MySQL SUM()
MySQL AVG()
MySQL MIN()
MySQL MAX()
Subquery
EXISTS Operator
CASE Statement
NOT EXISTS Operator
CTE (Common Table Expression)
Recursive Queries
Window Function
Index Command
Types of Index in MySQL
PRIMARY INDEX
UNIQUE INDEX
FULLTEXT INDEX
SPATIAL INDEX
CREATE INDEX
DROP INDEX
EXPLAIN Statement
Optimizing Queries and Joins in MySQL: Best Practices with Examples
< PREVIOUS
NEXT >
Types of Index in MySQL
There are following different types of indexing in MySQL:
PRIMARY Indexing
UNIQUE Indexing
FULLTEXT Indexing
SPATIAL Indexing
< PREVIOUS
NEXT >
RELATED INTERVIEW QUESTIONS
X