Learn MySQL Complete Guide (OFFLINE)

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.

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

We cover major topics like

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