MySQL Tutorial

MySQL TutorialWelcome to the MySQL Tutorial website! You will learn MySQL fast, easy and fun. In this website, we provide you with a complete MySQL tutorial that presents in a concise and easy-to-follow manner. Each tutorial has practical examples with SQL script and screenshots available.

Are you new here? If so, you can install MySQL database server, download MySQL sample database and load the sample database into your own local MySQL database server  to get started quickly.

MySQL Tutorial for Developers

Are you a web developer looking for learning MySQL fast? In this section, you will be getting started with MySQL right away. You will learn how to use MySQL effectively to get your work done more productively. If you go through the entire tutorials, you will know how to manage MySQL databases and manipulate data using various techniques such as SQL queries, MySQL stored procedures, database views, triggers, etc.

Basic MySQL Tutorial

Basic MySQL Tutorial
This section helps you get familiar with basic MySQL including managing MySQL database and manipulating data using various SQL statements such as INSERT, DELETE, UPDATE and SELECT. You will also learn about advanced data selection techniques including INNER JOIN, LEFT JOIN, Subquery, UNION, etc.

MySQL Tips

MySQL Tips
We provide you with the advanced MySQL techniques and tips to help you solve the most difficult challenges in MySQL effectively.

MySQL Stored Procedure

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

MySQL Triggers

MySQL Triggers
MySQL triggers are stored programs that are executed automatically to respond to specific events associated with table e.g., insert, update or delete a record. This section shows you how to work with MySQL database triggers.

MySQL Views

MySQL Views
In this section, you will learn what a database view is, how to create a database view and manage it in MySQL.

MySQL Full-Text Search

MySQL Full-Text Search
In this section, we show you how to use MySQL full-text search with various full-text searching techniques such as natural language search, Boolean language search and query expansion.

MySQL Functions

MySQL Functions
This section gives you the most commonly used MySQL functions including aggregate functions, string functions, date and time functions, and control flow functions.

MySQL Tutorial for Database Administrators

This step-by-step tutorial gives you in-depth background information on MySQL administration. It covers everything from basic to advanced MySQL administration and configuration. All MySQL administration tutorials presented in this section are practical and widely used in enterprise environments.

MySQL Administration

MySQL Administration
In this section, you will find a lot of useful MySQL administration tutorials including MySQL server start-up and shutdown, MySQL server security, MySQL database maintenance, backup and replication.

MySQL Programming Interfaces

In this section, we will show you how to write MySQL-based applications for accessing MySQL databases.

Python MySQL Tutorial

Python MySQL Tutorial
This Python MySQL tutorial section shows you how to use MySQL connector/Python to access MySQL databases.

PHP MySQL Tutorial

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.

Perl MySQL Tutorial

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 References

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