To use this website fully, you first need to accept the use of cookies. By agreeing to the use of cookies you also consent to allowing this site to collect anonymised information about your visit. For more information or to opt-out of analytics, read this page.

MySQL tutorial

Part 1 - An introduction

PartName
1.1
This tutorial covers MySQL in detail and is designed to give a step by step insight into how MySQL works and how to use it.

Part 2 - Getting started

PartName
2.1
This article of the MySQL tutorial shows you how relational database management systems work.
2.2
This article of the MySQL tutorial shows you how to connect to a MySQL host.
2.3
This article of the MySQL tutorial describes the data types in MySQL.
2.4
This article of the MySQL tutorial shows you how to create a database.

Part 3 - SQL basics

PartName
3.1
This article of the MySQL tutorial shows you how to insert data into a database.
3.2
This article of the MySQL tutorial shows you how to retrieve data from a database.
3.3
This article of the MySQL tutorial shows you how to use conditions in MySQL.
3.4
This article of the MySQL tutorial shows you how to remove data from a database.
3.5
This article of the MySQL tutorial shows you how to modify data in a database.
3.6
This article of the MySQL tutorial shows you how to use dates with SQL.

Part 4 - Joining tables

PartName
4.1
This article of the MySQL tutorial teaches the basics of joins.
4.2
This article of the MySQL tutorial shows you how to use inner joins.
4.3
This article of the MySQL tutorial shows you how to use left and right joins.

Part 5 - Advanced SQL

PartName
5.1
This article of the MySQL tutorial discusses the built in functions MySQL provides.
5.2
This article of the MySQL tutorial shows you how to organise data.
5.3
This article of the MySQL tutorial shows you how to create views.
5.4
This article of the MySQL tutorial discusses SQL injection.
5.5
This article of the MySQL tutorial describes transactions.