MySQL Tutorials - Herong's Tutorial Examples - Version 4.20, by Dr. Herong Yang
About This Book
This section provides some detailed information about this book - MySQL Tutorials - Herong's Tutorial Examples.
Website URL: http://www.herongyang.com/MySQL
Title: MySQL Tutorials - Herong's Tutorial Examples
Author: Dr. Herong Yang
Category: Database/MySQL
Version/Edition: Version 4.20, 2015
Number of pages: 137
Short description: 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...
Long description: 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... Key sections include: Relational Database Management System (RDBMS) - Installing MySQL - Introduction to MySQL - Accessing MySQL from Perl Programs - Data Types and Literals - Operations and Expressions - Functions - Table Column Types - Data Definition Statements - Data Manipulation Statements - Select Statements - Transaction Management - Locks And Deadlocks - MySQL - Stored Procedures - MySQL - Stored Procedure Language.
Keywords: CREATE, cursor, datatype, DATE, DBD, DBI, DELETE, deadlock, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, UPDATE, WHERE, Windows, XML.
Cost/Price: Free
Viewing statistics:
This book has been viewed a total of:
Revision history:
Copyright:
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
PHP 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