MySQL Tutorials - Herong's Tutorial Examples - v4.40, by Dr. Herong Yang
About This Book
Provides some detailed information about this book - MySQL Tutorials - Herong's Tutorial Examples.
Title: MySQL Tutorials - Herong's Tutorial Examples
Author: Dr. Herong Yang - Contact by email via herong_yang@yahoo.com.
Category: COMPUTERS / Database Administration & Management
Version/Edition: v4.40, 2020
Number of pages: 209
Description: This 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 introduction of Structured Query Language (SQL); installation of MySQL; using MySQL client program; accessing MySQL from PHP, Java and Perl programs; SQL data types, literals, operations, expressions, and functions; Statements of Data Definition Language (DDL), Data Manipulation Language (DML), and Query Language; stored procedures; transaction management; locks and deadlocks; managing MySQL server on Windows, Linux, and macOS. Updated in 2020 (Version v4.40): added Linux tutorials.
Keywords: CREATE, cursor, datatype, DBD, DBI, deadlock, export, FETCH, HAVING, import, INDEX, isolation, Linux, lock, macOS, MySQL, query, RDBMS, SQL, SQL-92, stored procedure, TIMESTAMP, transaction, Windows, XML.
Copyright:
Revision history:
Web version: http://www.herongyang.com/MySQL - Provides free sample chapters, latest updates and readers' comments. The Web version of this book has been viewed a total of:
PDF/EPUB version: http://www.herongyang.com/MySQL/PDF-Full-Version.html - Provides information on how to obtain the full version of this book in PDF, EPUB, or other format.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
Installing MySQL Server on Linux