About This Book: MySQL Tutorials

MySQL Tutorials - Herong's Tutorial Examples

∟About This Book

This section provides some detailed information about this book - MySQL Tutorials - Herong's Tutorial Examples.

Title: MySQL Tutorials - Herong's Tutorial Examples

Author: Herong Yang - Contact by email via herong_yang@yahoo.com.

Category: COMPUTERS / Database Administration & Management

Version/Edition: v4.46, 2023

Number of pages: 400

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 server on Windows, Linux, and macOS; using MySQL client program; accessing MySQL server 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; creating and using indexes; using window functions; stored procedures; transaction management; locks and deadlocks; InnoDB and other storage engines. Updated in 2023 (Version v4.46) with minor changes.

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:

This book is under Copyright © 1999-2023 Herong Yang. All rights reserved.
Material in this book may not be published, broadcasted, rewritten or redistributed in any form.
The example codes is provided as-is, with no warranty of any kind.

Revision history:

Version 4.46, 2023. Minor updates.
Version 4.30, 2019. Updated with MySQL 8.0.
Version 4.20, 2015. Updated with MySQL 5.7.
Version 4.00, 2010. Updated with MySQL 5.5.
Version 3.00, 2005. Updated with MySQL 5.0.
Version 2.00, 2002. Added tutorials on MySQL 4.0.
Version 1.00, 1999. Started with notes om mSQL.

Web version: https://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:

891,730 times as of December 2022.
839,367 times as of December 2021.
782,514 times as of December 2020.
735,650 times as of December 2019.
694,387 times as of December 2018.
650,153 times as of December 2017.
607,842 times as of December 2016.
558,151 times as of December 2015.
508,864 times as of December 2014.
438,410 times as of December 2013.
366,383 times as of December 2012.
293,865 times as of December 2011.
239,464 times as of December 2010.
176,151 times as of December 2009.
121,674 times as of December 2008.
87,073 times as of December 2007.
59,624 times as of December 2006.
54,562 times as of September 2006.
2,251 times as of March 2005.

PDF/EPUB version: https://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.