MySQL Tutorials - Herong's Tutorial Notes

http://www.herongyang.com/MySQL

Copyright © 2011 by Dr. Herong Yang. All rights reserved.

This free MySQL tutorial book is a collection of notes and sample codes written by the author while he was learning MySQL himself, an ideal tutorial guide for beginners. Topics include SQL, MySQL, database, table, column, index, null, insert, update, delete, select, order by, group by, deadlock...

Table of Contents

About This Book

Introduction of SQL

What Is SQL?

SQL History and Revisions

SQL and Database Terminologies

MySQL 4.0 Introduction and Installation

MySQL 4.0 Introduction

Installing MySQL 4.0.18

Creating First Table in MySQL

Installing MySQL 5.5.15

Installing MySQL 5.0.2 (Alpha)

Introduction of MySQL 5.0 Programs

List of MySQL Programs

mysqld - The MySQL Server Program

mysqladmin - The Client Tool for Administrators

mysql - The Client Tool for End Users

Using mysql to Run SQL Statements

mysqldump - Dumping Data to Files

mysqlimport - Loading Data from Files

Perl Programs and MySQL Servers

Accessing MySQL Servers from Perl Programs

HelloMySQL.pl - Sample Perl Program to Use MySQL

PHP Programs and MySQL Servers

Configuring PHP for MySQL Server Access

mysql_connect() and Other MySQL Functions

MySqlLoop.php - MySQL Functions Test

Java Programs and MySQL Servers

MySQL Connector/J - Download and Installation

Loading JDBC Driver Class - com.mysql.jdbc.Driver

JDBC Driver Connection URL

Creating Connections with DataSource Class

Getting Driver and Server Information

Creating Tables with AUTO_INCREMENT Columns

"INSERT INTO" Statements

Datatypes and Data Literals

Introduction of Datatype

Data Binary Representations

Data Literals

Data Literal Evaluation

Data Literal Evaluation Examples

Operations and Expressions

What Is Expression

Arithmetic Operations

Predicate Operations

Date and Time Operations

Examples of Different Types of Operation

Character Strings and Bit Strings

Operatins and Functions for Character Strings

Operatins and Functions for Bit Strings

Commonly Used Functions

Flow Control Functions

Character String Functions

Numeric Functions

Date and Time Functions

Cast Function

Table Column Types for Different Types of Values

Table Column Types for Character Strings

Table Column Types for Bit Strings

Table Column Types for Exact Numbers

Table Column Types for Approximate Numbers

Table Column Types for Date and Time Values

Using DDL to Create Tables and Indexes

CREATE TABLE - Statement to Create Tables

Column Options When Creating Tables

CREATE INDEX - Statement to Create Indexes

ALTER TABLE - Statement to Alter Table Structures

Using DML to Insert, Update and Delete Records

INSERT INTO - Statement to Insert Records to Tables

UPDATE - Statement to Update Records in Tables

DELETE FROM - Statement to Delete Records from Tables

Using SELECT to Query Database

SELECT Statements

FROM Clause of a SELECT Statement

JOIN -Operations to Join Two Tables

JoinTable.sql - Example of Join Tables

WHERE Clause of a SELECT Statement

GROUP BY Clause of a SELECT Statement

ORDER BY Clause of a SELECT Statement

Transaction Management and Isolation Levels

What Is a Transaction?

Transaction Management in MySQL

Transaction Isolation Levels

"Read Uncommitted" Isolation Level

"Read Committed" Isolation Level

"Repeatable Read" Isolation Level

Locks-Used-in-MySQL

Lock Types and Lock Levels

Table Level Locks in MySQL

Row Level Locks in MySQL

Defining and Calling Stored Procedures

What Is a Stored Procedures?

CREATE PROCEDURE - Statement to Create Stored Procedures

Stored Procedure Parameters

Variables, Loops and Cursors Used in Stored Procedures

Local Variables in Stored Procedures

Execution Flow Control Statements

ITERATE and LEAVE - Statements to Break Loops

DECLARE ... CURSOR FOR Select Statements

References

Printable Copy - PDF Version

Keywords: MySQL, SQL, Language, Database, Tutorial, Book

Previous Version: http://www.herongyang.com/sql/index.html