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
