Page Inspect

MySQL Tutorial - Learn MySQL Fast, Easy and Fun 🐬

Skip to content

- Home
- Start Here
- Basics
- Advanced
- Stored Procedures
- Triggers
- Events
- Views
- Indexes
- JSON
- Full-Text Search
- Administration
- Functions
- Aggregate Functions
- Comparison Functions
- Control Flow Functions
- Date Functions
- String Functions
- Window Functions
- Math Functions
- Regex Functions
- API
- PHP
- Python
- Node.js
- JDBC
- Perl
- TryIt

# MySQL Tutorial

Welcome to the **MySQL Tutorial** website, your go-to resource for mastering MySQL in a fast, easy, and enjoyable way.

Whether you’re a developer or a database enthusiast, our tutorials are designed to make learning MySQL a breeze.

Our tutorials are packed with clear explanations and practical examples to help you find everything you need to become proficient in MySQL.

## Getting Started

In this section, you’ll get started with MySQL by following five easy steps. After completing the getting started section, you’ll have a local MySQL database on your computer with a sample database to practice.

### Getting Started with MySQL

This section helps you get started with the MySQL quickly if you have never worked with MySQL before.

## MySQL Tutorial for Developers

Are you a developer looking to learn MySQL fast? After completing this section, you’ll know how to work with MySQL more effectively as a developer. You’ll learn various techniques to manipulate database objects and interact with the data.

### MySQL Basics

This MySQL basics section provides you with everything you need to know to manage data in MySQL effectively

### MySQL Stored Procedures

In this section, you will learn how to create stored procedures and stored functions in MySQL with clear explanation and practical examples.

### MySQL Triggers

MySQL triggers are stored programs executed automatically to respond to specific events associated with a table such as an insert, update or delete. This section shows you how to work with MySQL triggers effectively.

### MySQL Views

This tutorial introduces you to MySQL Views, which are named query stored in the database, and shows you step by step on how to manage views effectively.

### MySQL Index

This section introduces you to the MySQL index concept and shows you how to manage indexes in MySQL to optimize your queries.

## MySQL Programming Interfaces

In this section, you’ll learn how to access the MySQL Database using various programming languages such as PHP,  Java, Python, Node.js, and Perl.

### PHP MySQL Tutorial

You will learn how to interact with MySQL using PHP Data Objects or PDO, which provides a lightweight and consistent interface for accessing MySQL Database.

### MySQL Node.js

In this section, you will learn how to interact with MySQL from node.js applications using the mysql module.

### MySQL JDBC

Java JDBC API provides a standard interface to interact with any relational databases. In this MySQL JDBC tutorial section, we will show you how to use JDBC to interact with MySQL databases.

### Python MySQL

This page shows you how to use MySQL Connector / Python to interact with MySQL databases from Python programs.

### Perl MySQL Tutorial

This Perl MySQL section shows you how to interact with MySQL by using Perl DBI API for connecting to and disconnecting from MySQL databases, creating tables, handling data, and managing transactions.

## MySQL Tutorial for Database Administrators

This step-by-step tutorial provides you with in-depth background information on MySQL administration. This section covers everything from basic to advanced MySQL administration and configuration.

All MySQL administration tutorials presented in this section are practical and widely utilized in enterprise environments.

### MySQL Administration

In this tutorial series, you will learn about MySQL administration including security, maintenance, backups, and restores.

## MySQL Functions

### MySQL Aggregate Functions

Aggregate functions allow you to perform a calculation on a set of records and return a single value. In this tutorial, you will learn various MySQL aggregate functions including SUM, AVG, MAX, MIN and COUNT functions.

### MySQL Comparison Functions

In this section, you will learn about the comparison functions in MySQL including COALESCE, GREATEST, LEAST, and ISNULL.

### MySQL Control Flow Functions and Expressions

The control flow functions allow you to add if-then-else logic to SQL queries without using the procedural code.

### MySQL Date Functions

This page shows you the most commonly used MySQL Date Functions that allow you to manipulate date and time data effectively.

### MySQL String Functions

This page lists MySQL string functions that allow you to manipulate strings effectively.

### MySQL Regular Expressions

This section introduces MySQL regular expressions and offers you the most commonly used regular expression functions and operators in MySQL.

### MySQL Window Functions

This tutorial provides you with some practical and motivational examples of the window functions.

### MySQL Math Functions

This page explores the most frequently used MySQL mathematical functions with practical & real world examples.

## MySQL Tutorial References

If you need more information on MySQL, check out the MySQL resources.

Search for:

## Getting Started

- What Is MySQL?
- Install MySQL Database Server
- Connect to MySQL Server
- Download MySQL Sample Database
- Load Sample Database

## Querying Data

- SELECT FROM
- SELECT
- ORDER BY
- WHERE
- SELECT DISTINCT
- AND
- OR
- IN
- NOT IN
- BETWEEN
- LIKE
- LIMIT
- IS NULL
- Table & Column Aliases
- Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- Self Join
- CROSS JOIN
- GROUP BY
- HAVING
- HAVING COUNT
- ROLLUP
- Subquery
- Derived Tables
- EXISTS
- EXCEPT
- INTERSECT

## Managing Databases

- Select a Database
- Create Databases
- Drop Databases

## Managing Tables

- Create Tables
- AUTO\_INCREMENT
- Rename Tables
- Add Columns
- Drop Columns
- Drop Tables
- Temporary Tables
- Generated Columns

## MySQL Constraints

- Primary Key
- Foreign Key
- Disable Foreign Key Checks
- UNIQUE Constraint
- NOT NULL Constraint
- DEFAULT Constraint
- CHECK Constraint

## Insert data

- Insert Into
- Insert Multiple Rows
- INSERT INTO SELECT
- Insert On Duplicate Key Update
- INSERT IGNORE
- Insert DateTimes
- Insert Dates

## Update Data

- UPDATE
- UPDATE JOIN

## Delete Data

- DELETE JOIN
- ON DELETE CASCADE
- TRUNCATE TABLE

## MySQL Transactions

- Table Locking

## MySQL Data Types

- BIT
- INT
- BOOLEAN
- DECIMAL
- DATETIME
- TIMESTAMP
- DATE
- TIME
- CHAR
- VARCHAR
- TEXT
- BINARY
- VARBINARY
- ENUM
- BLOB

## MySQL Globalization

- MySQL Character Sets
- MySQL Collation

## MySQL Import & Export

- Import a CSV File Into a Table
- Export a Table to a CSV File

## About MySQL Tutorial Website

MySQLTutorial.org helps you master MySQL quickly, easily, and with enjoyment. Our tutorials make learning MySQL a breeze.

All MySQL tutorials are clear, practical and easy-to-follow. More About Us

## Latest Tutorials

- MySQL Port
- MySQL Commands
- innodb\_dedicated\_server: Configure InnoDB Dedicated Server
- innodb\_flush\_method: Configure InnoDB Flush Method
- innodb\_log\_buffer\_size: Configure InnoDB Log Buffer Size
- innodb\_buffer\_pool\_chunk\_size: Configure Buffer Pool Chunk Size
- innodb\_buffer\_pool\_instances: Configuring Multiple Buffer Pool Instances for Improved Concurrency in MySQL
- innodb\_buffer\_pool\_size: Configure InnoDB Buffer Pool Size
- MySQL InnoDB Architecture
- How to Kill a Process in MySQL

## Site Links

- Donation ❤️
- Contact Us
- About
- Privacy Policy

## Others

- MySQL Cheat Sheet
- MySQL Resources
- MySQL Books

Copyright © 2008 - Present by www.mysqltutorial.org. All Rights Reserved.