About

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.

Lesson 1: mysql – introduction

Lesson 2: mysql – installation

Lesson 3: mysql – administration

Lesson 4: mysql – php syntax

Lesson 5: mysql – connection

Lesson 6: mysql – create database

Lesson 7: drop mysql database

Lesson 8: selecting mysql database

Lesson 9: mysql – data types

Lesson 10: create mysql tables

Lesson 11: drop mysql tables

Lesson 12: mysql – insert query

Lesson 13: mysql – select query

Lesson 14: mysql – where clause

Lesson 15: mysql – update query

Lesson 16: mysql – delete query

Lesson 17: mysql – like clause

Lesson 18: mysql – sorting results

Lesson 19: using mysql joins

Lesson 20: handling mysql null values

Lesson 21: mysql – regexps

Lesson 22: mysql – transactions

Lesson 23: mysql – alter command

Lesson 24: mysql – indexes

Lesson 25: mysql – temporary tables

Lesson 26: mysql – clone tables

Lesson 27: mysql – database info

Lesson 28: using mysql sequences

Lesson 29: mysql – handling duplicates

Lesson 30: mysql – and sql injection

Lesson 31: mysql – database export

Lesson 32: mysql – database import – recovery methods

Lesson 33: mysql – useful functions

Lesson 33: mysql – useful resources

  •