Learn MySQL

MySQL Tutorial

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.

Audience

This tutorial is prepared for the beginners to help them understand the basics-to-advanced concepts related to MySQL languages.

Prerequisites

Before you start doing practice with various types of examples given in this tutorial, it is being assumed that you are already aware about what a database is, especially an RDBMS and what is a computer programming language.

Learn MySQL

MySQL - Home

MySQL - Introduction

MySQL - Installation

MySQL - Administration

MySQL - PHP Syntax

MySQL - Connection

MySQL - Create Database

MySQL - Drop Database

MySQL - Select Database

MySQL - Data Types

MySQL - Create Tables

MySQL - Drop Tables

MySQL - Insert Query

MySQL - Select Query

MySQL - Where Clause

MySQL - Update Query

MySQL - Delete Query

MySQL - Like Clause

MySQL - Sorting Results

MySQL - Using Join

MySQL - NULL Values

MySQL - Regexps

MySQL - Transactions

MySQL - Alter Command

MySQL - Indexes

MySQL - Temporary Tables

MySQL - Clone Tables

MySQL - Database Info

MySQL - Using Sequences

MySQL - Handling Duplicates

MySQL - SQL Injection

MySQL - Database Export

MySQL - Database Import

MySQL Useful Resources

MySQL - Useful Functions

MySQL - Quick Guide

MySQL - Useful Resources

MySQL - Discussion