MySQL Tutorials - Herong's Tutorial Examples by Herong Yang
English | July 27, 2021 | ISBN: N/A | ASIN: B07VQ2YGK2 | 575 pages | EPUB | 0.55 Mb
English | July 27, 2021 | ISBN: N/A | ASIN: B07VQ2YGK2 | 575 pages | EPUB | 0.55 Mb
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 2021 (Version v4.42) with minor changes.