MySQL Tutorials - Herong's Tutorial Examples - v4.40, by Dr. Herong Yang
PHP Programs and MySQL Server
Provides notes and tutorial examples on MySQL server and PHP programs. Topics include configuring the PHP engine to use the MySQL extension library, commonly used MySQL functions, running SQL statements to create table, insert rows and fetch rows.
Configuring PHP for MySQL Server Access
MySQL Authentication Method "caching_sha2_password"
Takeaways:
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
►PHP Programs and MySQL Server
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